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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Dellis81
Continued Contributor
Continued Contributor

Swapping visuals based on matrix measure

Hello - I am looking for ways to swap visuals based on a measure within a matrix.  So for example - if the user clicks on a certain "cell" (row and measure) within the master matrix (circled in blue)- then the appropriate set of visuals is displayed on the right.  I'm envisioning the right side of visuals could be hidden/viewed based on bookmarks.

 

I am using tooltips in both sets of tables - and I don't seem to be having positive user experiences with drillthru

I have tried navigation bottons, but when I click on a certain botton, then the "selection" is lost in the master matrix.

 

MatrixSwap based on measure.PNG

 

Please advise if there is some magic technique or blog that I can dig into.

thanks

2 REPLIES 2
Dellis81
Continued Contributor
Continued Contributor

Thanks for responding...   By "appropriate visuals" - most likely be a group of visuals that relate to the row (dimension) and column (measures).    I have been able to make work with bookmarks, and when I flip back and forth using the book mark pane - I get what I want.   But when I create a botton assigned to a particalur bookmark - I loose the selected (focused) row/column within hte master matrix - and my filter goes back to a default/wide open filter.
For now - I have setup a drill thru page that gets closer and does what I want.  However, my user feedback is to keep all on a single page.

Think my real issue is not allowing interactions between the botton and master visual.  But I am not finding a way to shut this interaction off for bottons?

thanks!

lbendlin
Super User
Super User

Can you give an example for "appropriate set of visuals"? Do you want to toggle one visual for another, or show different groups of visuals?   Have you considered using different report pages instead?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors