topic Re: Radar Chart not responsive to selected table row? in DAX Commands and Tips

Radar Chart not responsive to selected table row?

daanodinot — Mon, 31 Oct 2022 11:30:49 GMT

It seems that the Radar Chart (available separately) is responsive to some filter context changes but not all. For example, it reponds to changes caused by the Text Filter (also available separately). But it doesn't respond to any row you select in a Table visual. Take this Measure I made for the Chart's Y axis:

Chart Measure = SWITCH( VALUES(TasteList[Taste Key]), 1, AVERAGE(Taste[Sweet]), 2, AVERAGE(Taste[Sour]), 3, AVERAGE(Taste[Salty]), 0 )

If I search with the Text Filter, the averages for the filter context of the Radar Chart change accordingly. But if I then select a row in a Table visual, the averages stay the same.

However! When I put one of the AVERAGE functions in a Card visual the average does change with the selected row.

So it seems to me that the Radar Chart cannot respond to the selected row in a Table visual. Am I right?

Re: Radar Chart not responsive to selected table row?

Anonymous — Tue, 01 Nov 2022 07:53:04 GMT

Hi daanodinot ,

I create a sample to have a test and the columns in Table visual could filter the Radar Chart in my side.

According to your statement, I think you may check whether there are relationship between the columns in two visuals or check the interaction between the Table visual and Radar Chart by "Edit interaction" feature.

If the interaction between two visuals is "None", your selection in Table visual is not able to filter the Radar Chart.

For referernce: Change how visuals interact in a Power BI report

Best Regards,
Rico Zhou

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

Re: Radar Chart not responsive to selected table row?

daanodinot — Tue, 01 Nov 2022 17:21:00 GMT

Ah, got it! Turns out that when you select a Table visual, a third interactions icon is added to the Radar Chart called Highlight. Microsoft made the bad call (in my opinion) to select this Highlight mode by default. The icon also looks *way* too much like the Filter icon.

Thank you for reminding me to check the interaction settings once again. 🙂