Change title of Clustered Column Graph dynamically based on selection in Radar Chart

[Daxaniie]

I have the dataset below. There are 4 different categories with 2 associated values.

With that, I have created a Radar chart on the left to show the average of each value by category and a clustered column graph on the right to show the overall average for all categories.

I also created a measure below and used it to format the title of the column graph on the right. The aim is that when someone clicks the datapoints corresponding to each category on the radar chart, the title of the bar graph will change dynamically to reflect the chosen category.

However, when I click on the data point corresponding to the West category on the Radar chart, the column graph is cross-filtered based on the selection but the title does not reflect the chosen category as West and instead shows “All Categories”. I don’t think the issue is with the title measure because this method works for other graphs.

May I know if there is a workaround for this? Thank you.

[amitchandak]

@Daxaniie m can you share sample pbix after removing sensitive information

[Daxaniie]

Hi @amitchandak I have attached link to the file. Thanks!

https://smu-my.sharepoint.com/:u:/g/personal/daxaniies_2018_mitb_smu_edu_sg/ESYUmjgrp_9LkQFG7UsgEsAB...

[v-yiruan-msft · Accepted solution]

Hi @Daxaniie ,

Here is a workaround: add one Card visual, then drag the measure "title" on this card visual. 

Best Regards

Rena

[Daxaniie]

@v-yiruan-msft Awesome, this solution works! Thank you!