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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
UAV-Test-Pilot
Helper II
Helper II

Highlight (Cross-Filter Visualization Interactions) from Multiple Visualizations

I am trying to have a report highlight from multiple visualizations selections, but cannot get it to work. I have about 10 visualizations on one report, and when I filter by clicking on a value (or control-click multiple values) inside one visualization, all other visualizations correctly update. However, when I go to viz1 and make and a selection(s) then make a selection(s) in viz2, my viz1 selections go away.

 

What I want to do is go inside visualization 1, select a row to highlight all other visualizations, then go to visualization 2 to further filter the data.

 

I could do this with the actual filter pane, but I don't know ahead of time what values I am interested in. What I want is something like chained adhoc filtering / highlighting, where selections in one viz are retained when I switch focus to a different viz.

 

Is this a current feature? Is this a planned feature? Can I make this possible with some custom DAX, measures, data trickery? Does this have to be an App / Dashboard and not a report?

 

The primary method of consumption of this report / app will be on the server, not Desktop if that changes anything.

1 ACCEPTED SOLUTION
UAV-Test-Pilot
Helper II
Helper II

Well I feel stupid.... just tried again in Desktop and it works. Selecting viz1, then while holding control select viz2 value, it correctly applies both filters.

 

Works in desktop, reports on server, and app on server. Mark it up to user error I guess.

View solution in original post

3 REPLIES 3
UAV-Test-Pilot
Helper II
Helper II

Well I feel stupid.... just tried again in Desktop and it works. Selecting viz1, then while holding control select viz2 value, it correctly applies both filters.

 

Works in desktop, reports on server, and app on server. Mark it up to user error I guess.

I'm trying to cross-highlighting between a Tornado Chars and a Pie chart but the visuals just filter eachother and ignores past selections.
What I've tried:
1) to change 'Edit Interantions', but no combination gives me the results I want.
2) to change The Data model but it does't appear to be the cause, simply because the 'shape map' crossfilter well despite having the same data structure of the population pyramid.

Thanks for your attention. I’m looking forward to your reply

CaptureCrossHighlighting.PNG

 

@ahiguera Can you explain in more detail what happens?

 

If you select "60-64 Anos" and then select "Con erosiones", does your selection of "60-64 Anos" go away?

Are you sure you hold down the control button when you choose Con erosiones"?

 

Can you post a picture of the interactions of each visuzliazation?

Can you post a picture of your data model?

 

My first guess would be that you have cross filtering turned off in the data model, or your tables are not linked correctly

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.