topic Re: Creating Customized Legend and Tooltip for Clustered Column Chart in Custom Visuals Development Discussion

Creating Customized Legend and Tooltip for Clustered Column Chart

betelgeutsen — Fri, 21 Jul 2023 09:37:14 GMT

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! ❤️

Re: Creating Customized Legend and Tooltip for Clustered Column Chart

lbendlin — Sun, 23 Jul 2023 18:20:43 GMT

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

Add the appropriate measures to the tooltips area.

Re: Creating Customized Legend and Tooltip for Clustered Column Chart

betelgeutsen — Tue, 01 Aug 2023 02:30:12 GMT

Do you have references for the DAX?

Re: Creating Customized Legend and Tooltip for Clustered Column Chart

lbendlin — Tue, 01 Aug 2023 12:56:51 GMT

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