How to Connect One Slicer to All Your Power BI Report Pages
And another one bites the dust… this month the Power BI team have only delivered the #1 most requested feature on the Power BI Ideas forum.
Category: Slicers and Disconnected Slicers
Dynamic Attributes In A Power BI Report
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
Today, I’ll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles… and yes, I’ll throw in a Greatest Formula In the World (GFITW) version, too.
DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
First off…my first post! Being one of the newest (and youngest) members of the P3 Adaptive family has been very exciting so far. As a way of introducing myself, I’d like to share a creative solution to a problem I’m sure many of you have encountered when building a report or dashboard.
Dynamic TopN Reports via Slicers, Part 3
After Rob posted Dynamic TopN Reports Using PowerPivot2!, I downloaded the workbook from the provided link to examine how his “tricks” were done
Wingdings and Other Symbolic Fonts in Slicers!
Someone planted an idea in my head the other day: “hey can we use the Wingdings font in slicers?”
Dynamic TopN Reports via Slicers, Part 2
OK, picking up from Tuesday’s post, with the goal of explaining the techniques. And remember, you can download the workbook here! Two Disconnected Slicers Ah, another favorite technique. Slicer tables […]
DAX – Comparing scientific and other data across trials
Enjoying the new forum! I’ve been spending some time on the Mr. Excel PowerPivot forum over the past few days and I must say I am enjoying the experience.
Adding State Alpha Sort to the Sort By Slicer Trick
Sorting by State! How did I miss that? In a comment on Thursday’s post, Janet asked an excellent question: what about sorting by state name?