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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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