cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UAV-Test-Pilot Regular Visitor
Regular Visitor

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 Regular Visitor
Regular Visitor

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 Regular Visitor
Regular Visitor

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 Frequent Visitor
Frequent Visitor

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

 

UAV-Test-Pilot Regular Visitor
Regular Visitor

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors