cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atrinhatra Member
Member

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. 

 

stacked.png

2 REPLIES 2
Super User
Super User

Re: Stacked barchart tooltips

Perhaps something like:

 

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

And use that for your tooltip.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


atrinhatra Member
Member

Re: Stacked barchart tooltips

,

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