Reply
betelgeutsen
Frequent Visitor

Creating Customized Legend and Tooltip for Clustered Column Chart

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.

betelgeutsen_1-1689931963659.png

Thank you in advance for your help! ❤️

3 REPLIES 3
betelgeutsen
Frequent Visitor

Do you have references for the DAX?

lbendlin
Super User
Super User

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

Add the appropriate measures to the tooltips area.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)