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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.