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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

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
Gordonlilj
Solution Sage
Solution Sage

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.

Anonymous
Not applicable

Hello,

 

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

 

Sincerely,

 

Peter

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

Anonymous
Not applicable

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

Anonymous
Not applicable

Any other ideas?

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors