topic Re: Just show the right tooltip, depending on the year in Custom Visuals Development Discussion

Just show the right tooltip, depending on the year

edubcardoso — Mon, 17 Oct 2022 11:13:55 GMT

Hello everyone !

I create a line and clustered column chart where the dark colors (dark blue and red) are this year's values and the light colors(light blue and yellow) are last year's values.

I created a tooltip to show the value of the rows when I select a column, but it shows me the tooltip for the both years (example below)

(tooltip for set this year)

(tooltip for set last year)

I wanted the tooltip to only show one of the profits, depending on the year.

In the first image only revenue.

In the second, only revenue lastyear

Is there any way to do this ?

Thanks for the help.

Re: Just show the right tooltip, depending on the year

Greg_Deckler — Mon, 17 Oct 2022 11:57:12 GMT

@edubcardoso You could create a Tooltip page to display only the information you want to display.

Re: Just show the right tooltip, depending on the year

edubcardoso — Mon, 17 Oct 2022 12:27:29 GMT

@Greg_Deckler

Thank you for answering, mate!

I just found out about that just now, but I don't know how It would go from this year's measure to the previous year's measure.

Maybe using an IF( statement ,[Sum],[Sum LastYear]), but which statement should I use ?

(Sorry for the bad English, but it was translated by DeepL)

Re: Just show the right tooltip, depending on the year

Greg_Deckler — Mon, 17 Oct 2022 12:53:45 GMT

@edubcardoso I have a presentation for Enterprise DNA coming out soon on Dueling Tooltips. I've attached the PBIX file for you below my signature. This might give you some ideas.