Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Schmidtmayer
Helper II
Helper II

Switch grouped dimension via filter

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

Schmidtmayer_2-1631194179921.png

 

grouped by property1:

Schmidtmayer_3-1631194463408.png


grouped by property2:

Schmidtmayer_4-1631194510579.png

 





1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.