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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Yagevendra
Helper IV
Helper IV

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors