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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Visuals are not filter as expected with each other

Hi All,

I have created a Power BI dashboard with tow vusulizations: A pie chart and a stacked column chart. Both charts represent data with a simple calcualtion, Using "Category" for the legend and a count of records for the values.

My objective is to establish interactions between these visual with the specific filtring criteria:

1 : When a category is selected in the stacked column chart. It should act as a filter for the pie chart, Displaying only the chosen category while removing other categories.

2 : When a slice is selected in the pie chart, It should filter the stacked column chart, Displaying only the selected category, similar to how its work when selecting from the stacked column chart.

I seek assistance in achieving this desired behavior, as i have encountered an issue where the Pie charts selection highlights the category but doesn't filter the stacked column chart as expected.

Please find below screenshot of the report :

2 slice or may be we can select one slice in pie chart it only highlighted the stacked column chart.

Yagevendra_0-1699451456752.png

Now i have selected a category from stacked column chart its filtring the category as expected.

Yagevendra_1-1699451575804.png

 

1 ACCEPTED SOLUTION
JohnnySaade
Helper I
Helper I

Click on one of the visuals -> Format -> edit interactions -> click on the filter icon that appeared on the other visual. Do the same for the second visual.

View solution in original post

1 REPLY 1
JohnnySaade
Helper I
Helper I

Click on one of the visuals -> Format -> edit interactions -> click on the filter icon that appeared on the other visual. Do the same for the second visual.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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