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 ...
Need Help
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