Remove empty values in a line chart

[#1]

Hello

I am trying to hide the lines in the line chart where the values are equal= 0. I had no problem doing this in a straight table. I just added C_ACT2<>0 in the presentation tab under conditional columns, but I don't know how to to do it in the line chart.

For example:(in the below picture)

I have C_ACT2 and C_ACT2_BASE they don't actually appear in the line chart but they are assigned a color by default. Can I remove them from the list, since their value is 0?

All the values that are 0 are removed from the Straight table. Therefore, the values shown in the straight table are the same that should be shown in the line chart.

Any suggestions on how to do this?

Thanks in advance

[#2 · Accepted solution]

Hi,

In your expressions for C_ACT2 and C_ACT2_BASE you have to use an IF like this:

if(sum(Sales) > 0 , sum(Sales), '')

Hope this helps

Regards!

[#3]

Thanks Gabriela

That solved my issue.