Forum Discussion

edubcardoso's avatar
edubcardoso
Icon for Advocate I rankAdvocate I
3 years ago
Solved

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.

3 Replies

    • edubcardoso's avatar
      edubcardoso
      Icon for Advocate I rankAdvocate I

      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)