Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
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=p...
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=p...
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
79 | |
73 | |
58 | |
36 | |
32 |
User | Count |
---|---|
90 | |
62 | |
61 | |
49 | |
45 |