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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Effect of Filtering a Chart

Hey Community, 

I am currently working on a report where I use several Charts (Pie Charts, Bar Charts, ..). 

When I filter on a certain value in another Chart ( Drillthrough)

Jonny_Walk_3-1702289466762.png

then the charts show the value of the filtered population relative to the whole poulation:

Jonny_Walk_0-1702288964441.png

But I would like the whole chart to update if a filter is applied by another Chart. So for example if I am filtering for a certain year I want my distribution in that certain year. So something  looking like this: 

Jonny_Walk_1-1702289062600.png

How can I achieve this?

 

If you have any questions about what I mean do not hesitate to ask.

Thanks!!!

 

Jonny

 

 

 

1 ACCEPTED SOLUTION
Corey_M
Resolver II
Resolver II

the thing you are looking for is editing interactions.

Click on whatever is controlling your year (be it another visual or slicer) 
Click Format in the Ribbon
Click edit interactions
 While still on the visual that controls your year there should be these icons in the top right of your pi chart:

Corey_M_0-1702326667222.png

Make sure the one on the far left (Filter) is selected

Here's the documentation if you are looking for more information:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

View solution in original post

1 REPLY 1
Corey_M
Resolver II
Resolver II

the thing you are looking for is editing interactions.

Click on whatever is controlling your year (be it another visual or slicer) 
Click Format in the Ribbon
Click edit interactions
 While still on the visual that controls your year there should be these icons in the top right of your pi chart:

Corey_M_0-1702326667222.png

Make sure the one on the far left (Filter) is selected

Here's the documentation if you are looking for more information:
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.