Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello there, photos of sample data below.
The dataset contains a facttable including 2 columns to group (value 1 and value 2) by certain property coloumns (property1 and property2).
I do know it is possible to switch between displayed measures using DAX, as shown in the sample data. I am interested in the following: Is it possible to switch VIA FILTERS between the grouped properties?
Means: I want add another filter with options property1 and property2. Choosing property1 reveals page 1 of the report, values grouped by property1. Choosing property2 will show the values grouped by property2. Is this possible?
A solution via filters prefered, as the current solution is to have, just like the report, one page for every property to be grouped by and switching via tab navigation.
In genereal, the number of values may increase, as well as the number of properties to be grouped by. Also, every property may have a different number of options, some being binary, some being multivalued.
Thanks in advance
DataSet:
FactTest conntected to DimProperty1 via DimPropert1.ID and FactTest.property1
FactTest conntected to DimProperty2 via DimPropert2.ID and FactTest.property2
DimSwitch used for switching measures via filters
grouped by property1:
grouped by property2:
Solved! Go to Solution.
Enable "Personalize Visual" and teach your users how to do it (and how to swap dimensions). If you don't like that, use bookmarks to show/hide individual visuals.
Enable "Personalize Visual" and teach your users how to do it (and how to swap dimensions). If you don't like that, use bookmarks to show/hide individual visuals.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
10 | |
10 | |
9 | |
6 |