Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to 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.
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
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.
User | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |