Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Stacked barchart tooltips

Hi, 

Is it possible to have a hide one part of tooltips and only show have one shows on this bar chart and if so how ? example below ; I want to have a tooltip show for blue and not yellow.

I have two measures on value filed, yellow present loss and blue present gain. 

 

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Perhaps something like:

     

    Measure 3 = 
IF(MAX([Column1])="Cat1",BLANK(),SUM([Column2]))

    And use that for your tooltip.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      ,

      thanks for your reply,

      I have tried to use your solution but i seem to have trouble with code,

      you suggested

      Measure 3 =
      IF(MAX([Column1])="Cat1",BLANK(),SUM([Column2]))

      I matched it to my report as

      Measure 3 =
      IF(MAX([bluebar])="Cat1",BLANK(),SUM([ .............

      but the "yellowbar" measure not coming up for the second part of the code ??

      what cat1 stand for ?

      thanks