Forum Discussion
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)
then the charts show the value of the filtered population relative to the whole poulation:
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:
How can I achieve this?
If you have any questions about what I mean do not hesitate to ask.
Thanks!!!
Jonny
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: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=powerbi-desktop
1 Reply
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: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=powerbi-desktop