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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.