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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors