Dynamic title for a bar chart linked with a matrix

[hainguyen28]

I have a matrix with sales of 3 different categories, and an accompany bar graph as follow:

I want to create a dynamic title for the bar chart. For example, if I click on Office Supplies in the matrix, then the title of the bar chart would be Total Sales for Office Supplies. Same thing for Furniture and Technology. 

Can anyone please show me how to do that?

[Anonymous]

Hi @hainguyen28 ,

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.
If not, please provide a more detailed description, preferably some virtual sample data, and the expected results.

Best Regards,
Stephen Tao

[Ritaf1983 · Accepted solution]

Hi @hainguyen28 
Since the essence of a dynamic title lies in indicating whether the visualization is filtered, this can only work if you set the interaction to "filter" rather than "highlight."

So you should modify interactions for "filter" 

And then use measure like :

The pbix is attached

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