Creating Customized Legend and Tooltip for Clustered Column Chart

[betelgeutsen]

Hi everyone!

I hope you can help me with a visualization challenge I'm facing. I have created a clustered column chart to display year-on-year (YoY) inflation based on different cities. The chart shows two columns for each city: one for the current quarter and year's YoY inflation and the other for the YoY inflation from the previous quarter. I have also filtered the data based on selected quarters and years.

Now, my question is: How can I customize the legend and the tooltip to dynamically adjust based on the selected filter values?

For instance, if I select "Quarter I" and "2019" from the filters, I want the legend to show "QI 2019" for the current quarter and "QIV 2018" for the previous quarter. Similarly, I want the tooltip to display the respective inflation values for the selected quarters.

Is there a way to achieve this in Power BI? I would greatly appreciate any insights or solutions you can provide.

Here I attached an illustration of my current chart for reference.

Thank you in advance for your help! ❤️

[betelgeutsen]

Do you have references for the DAX?

[lbendlin]

This may help: Create report tooltip pages in Power BI - Power BI | Microsoft Learn

[lbendlin]

Similarly, I want the tooltip to display the respective inflation values for the selected quarters.

Add the appropriate measures to the tooltips area.