cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UAV-Test-Pilot Helper I
Helper I

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

Accepted Solutions
UAV-Test-Pilot Helper I
Helper I

Re: Highlight (Cross-Filter Visualization Interactions) from Multiple Visualizations

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 I
Helper I

Re: Highlight (Cross-Filter Visualization Interactions) from Multiple Visualizations

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

ahiguera
New Member

Re: Highlight (Cross-Filter Visualization Interactions) from Multiple Visualizations

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

 

Highlighted
UAV-Test-Pilot Helper I
Helper I

Re: Highlight (Cross-Filter Visualization Interactions) from Multiple Visualizations

@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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors