Skip to Content
0
Former Member
May 20, 2014 at 05:33 AM

Hiding measure values line chart

126 Views

Hie Guys,

I have a line chart with measure object "X" and dimension "Month". Now, the measure values are going to be zero for all previous months. I do not want those zero values to be displayed in the line chart. Is there a way to do this in Webi? I tried to create a variable to substitute Measure object X.

Variable = If (Measure Object =0) Then "" Else Measure Object. This did not work as the chart only takes measures and the variable is text. Anybody have any suggestions? Thanks.