Interaction issue between Table visual and Pie charts

[Anonymous]

Hi Experts,

My visuals are not interacted properly .

When select any partitions in pie chart , the table is not filtering as per the selection , instead it is showing all the rows but highlighting the expected rows with the forecast & revenue values , so rest all the blank rows are not expected  

Please help to sort this issue ..

let me know if need more details ..

Thanks

DK

[SNKrishna]

Got it, usually that is not the expected behaviour of the visuals. Only thing I suspect is, if you have used any DAX on the columns that you pulled into the visual, like ALL, ALLExcept or KEEPFILTERS, there maybe a chance these DAX is effecting the visual rendering. If this didnt resolve the issue, better create a support ticket with Microsoft, they will do proper investigation. 

[SNKrishna]

As you mentioned, you are seeing the expected result is highliting but not getting filterd, issue could be with the Edit interactions configured on the visuals. Maybe this could help, select the pie chart, this will give you the Format menu as below:

Under Fromat menu, select edit interactions and then select the desired option, as you want to filter the data in table visual, select Filter icon on the top right corner of the Table visual as below:

If this dosent resolve the issue, my understading of your issue is worng, please eloborate more and will try to help you out. 

[SNKrishna]

As you mentioned, you are seeing the expected result is highliting but not getting filterd, issue could be with the Edit interactions configured on the visuals. Maybe this could help, select the pie chart, this will give you the Format menu as below:

Under Fromat menu, select edit interactions and then select the desired option, as you want to filter the data in table visual, select Filter icon on the top right corner of the Table visual as below:

If this dosent resolve the issue, my understading of your issue is worng, please eloborate more and will try to help you out. 

[Anonymous]

Hi @Anonymous ,

Thank you Rupak_bi for your reply. His reply explains some possible scenarios. According to your description, you are selecting a particular piece on the pie chart for a table visualization that does not perform the hiding of disjointed data. After testing, when you select the data in the table visualization, enabling highlighting will gray out the irrelevant data in the pie chart, but on the contrary the pie chart can't go to manipulate the table visualization. So, there is no way to tell what is causing this situation, it would be best if you could provide the sample pbix file so we can help you faster. Please hide sensitive information in advance. In the meantime, you can also check if the following documentation is helpful for you.

Change how visuals interact in a report - Power BI | Microsoft Learn
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

Understand how visuals interact in a report - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Rupak_bi]

hi @Anonymous 
select the pie chart > go to edit interaction from format tab> now you will get option on the top right corner of the marix visual for highlighting /filtering. from there select the filtering option.

[Anonymous]

@Rupak_bi  @SNKrishna @Anonymous 

Filter is already selected .. and filter is working fine but it is highlighting the resulted rows but not filtering result alone.

Pie chart to Pie chart edit interaction only having filter/highlight options but not in table visual :