Dynamic Data Labels and Tooltips (not title) base on selection

Question

Is it possible to do dynamic data label and tooltip inside a visual?

I have a slicer for years, I like to show 3 years of Margin (SY, SY -1, and SY-2) base on what the user selected from the slicer.

I created new measure columns as follow:

Margin TY = SUM(ClientWeeklySummary[GROSSMARGIN])

Margin LY =CALCULATE (ClientWeeklySummary[CS_Gross Margin TY],DATEADD ( Fiscal[Fiscal], -1, YEAR))

Margin LLY=CALCULATE (ClientWeeklySummary[CS_Gross Margin TY],DATEADD ( Fiscal[Fiscal], -2, YEAR))

I created a dynamic title Gross Margin (SY/SY-1/SY-2) but is it possible to change the name of the data labels?

Margin TY to Margin [SY]

Margin LY to Margin[SY-1]

Margin LLY to Margin[SY-2]?

mfelix · Answer

Hi&nbsp;Eddie9394&nbsp;,
&nbsp;
As in the field values if you double click the Tooltips you can change the name that appears:
&nbsp;

&nbsp;
In my example I use columns but you can also do it with measures.
&nbsp;
Regards,
MFelix

eddie9394 · Answer

Thank you for your reply!&nbsp; Yes, I did that, but can I change the name dynamically based on selected value (in my case Year)?&nbsp; &nbsp; &nbsp;

mfelix · Answer

Hi Eddie9394,You cannot do that with the default tooltip, the workaround is to create a tooltip page and add it to your visual. Regards, MFelix

Forum Discussion