Hiding measure values line chart

[former_member672670]

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.

[Former Member · Accepted solution]

Jeewan,

Right click on Line Chart -- Global --- General -- Just uncheck SHOW MEASURE VALUES WHEN VALUE=0.

Find the screen shots.

[former_member672670 · Accepted solution]

This is not going to work because I have 3 measure objects inside the charts. Thus, for a particular month, measure 1 might be zero, but measure 2 & 3 might not. Any other way?

[Former Member · Accepted solution]

Jeewan, Consider this as sample data.

Now create three variables....

Month 1 = [M1] Where ([M1]<>0)

Month 2 = [M2] Where ([M2]<>0)

Month 3 = [M3]  Where ([M3]<>0)

Now your data will be

Right Click on it. Turn into Line Chart. Finally your output is as you required.

Regards,

G Sujitha

[former_member672670 · Accepted solution]

Thanks. That worked for me.

[Former Member]

use report or tab level filters for that measure.