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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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