Just show the right tooltip, depending on the year

[edubcardoso]

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.

 

 

[Greg_Deckler]

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

[edubcardoso]

@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)

[Greg_Deckler · Accepted solution]

@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.