Forum Discussion
Visual level filtering behavior in Power BI
this is my data
| Jan | 2 | A |
| Jan | 3 | B |
| Jan | 4 | C |
| Feb | 3 | A |
| Feb | 3 | B |
| Feb | 2 | C |
| Mar | 3 | A |
| Mar | 3 | B |
| Mar | 3 | C |
Using this data, I have created two visuals: a stacked column chart and a pie chart.
When I click on any field in the stacked column chart, the pie chart is also filtered accordingly based on the selected data.
When I click on a filtered segment in the pie chart, it selects all the values that belong to that particular field
The pie chart is not filtering based on the previously applied filter; instead, it shows all values for the selected field. Is this the default behavior in Power BI, or is there a way to control this?
If you want to keep the previous filter, you need so press CTRL before applying the new filter
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
In Power BI this is the default behavior when you click on a pie chart slice, it only filters by that field (Category) and ignores the previously applied filter.
To control this you can either:
-
Select pie chart >> Go to Format >> Edit Interactions and set the pie chart interaction to Filter, or
-
Use a Category slicer instead of relying on pie chart selection.
-
5 Replies
If you want to keep the previous filter, you need so press CTRL before applying the new filter
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
it helps , thank you
In Power BI this is the default behavior when you click on a pie chart slice, it only filters by that field (Category) and ignores the previously applied filter.
To control this you can either:
-
Select pie chart >> Go to Format >> Edit Interactions and set the pie chart interaction to Filter, or
-
Use a Category slicer instead of relying on pie chart selection.
-
Hi RajeshKannanS,
Thank you rohit1991, for your helpful insights.
Since this is the visual default behavior, here is the link on how to create and edit interactions.
Change how visuals interact in a report - Power BI | Microsoft Learn
Thank you.
Yes — this is default behavior in Power BI.
Stacked column → Pie chart: applies a cross-filter (context carried forward).
Pie chart → Stacked column: applies a highlight on that category, ignoring earlier filters.
You can control this using:
Format → Edit interactions → change from Highlight to Filter.
Or redesign with slicers if you want consistent filtering across visuals.
