Forum Discussion
Just show the right tooltip, depending on the year
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.
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.
3 Replies
- Greg_Deckler
Community Champion
edubcardoso You could create a Tooltip page to display only the information you want to display.
- edubcardoso
Advocate I
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
Community Champion
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.