Visual level filtering behavior in Power BI

[RajeshKannanS]

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?

[FBergamaschi · Accepted solution]

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

[Shahid12523]

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.

[v-saisrao-msft]

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.

[rohit1991 · Accepted solution]

Hi @RajeshKannanS 

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.
  

[FBergamaschi · Accepted solution]

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

[RajeshKannanS]

it helps , thank you