cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pkoel-asb Regular Visitor
Regular Visitor

Loosing filter when I click out of visualization

Hello,

 

   I have a pie-chart visualization, that displays the total sales for each sales rep. Below the pie chart, I have a table visualization that lists the customer names for the entire company. When I select a specific sales rep from the pie chart, the table changes and displays the customers for the chosen rep. When I click on the name of a customer, the pie chart wedge (for the chosen sales rep) and the hole chart goes grey; The table listing all of the customers also goes grey and reverts back to displaying all of the customers for the entire company. I seem to be loosing filters when I click off of visualizations. Can you explain why?

 

Sincerely,

 

Peter

5 REPLIES 5
Super User I
Super User I

Re: Loosing filter when I click out of visualization

Hi,

 

I believe when you select the sales rep from the pie chart you filter all other visuals after what you selected on the pie chart. If you then select something from the table it will change so the visuals are filtered after what you selected in the table thereby losing the selection you made on the pie chart. You could see it like the single selection option that slicers have.

 

Holding down ctrl while selecting should allow you to keep the previous selection you've made.

pkoel-asb Regular Visitor
Regular Visitor

Re: Loosing filter when I click out of visualization

Hello,

 

   Thank you for the quick reply. When I click off the visualization, how can I retain the filter?

 

Sincerely,

 

Peter

Super User I
Super User I

Re: Loosing filter when I click out of visualization

The best way i can think of right now would be as i mentioned. Pressing and holding down left ctrl while selecting the values from the pie chart and table

pkoel-asb Regular Visitor
Regular Visitor

Re: Loosing filter when I click out of visualization

Hi,

 

   I changed the interactions between the visualizations so that when I click on the table, it should not change the pie chart; yet it still does. without holding the CTRL key, what is another way to retain that fileter?

 

Peter

pkoel-asb Regular Visitor
Regular Visitor

Re: Loosing filter when I click out of visualization

Any other ideas?

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.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors