Replace 0 with null on column

Hello,

I am trying to change some zero values with null because they show on the graph and they look ugly. I have tried with the function nullif but it says it is not supported when I try to create a table calculation. Is there any way to change those zeros by nulls as the data is not available? Thanks!

49d4df36-bce3-45dc-8198-0805365802c1.png

Thanks!

Solved Solved
1 2 4,139
1 ACCEPTED SOLUTION

Shru
Participant III

Hi, this worked for me as a table calculation. You can give it a try.

if(coalesce(${yourmeasure},0)=0,null,${yourmeasure})

View solution in original post

2 REPLIES 2

Shru
Participant III

Hi, this worked for me as a table calculation. You can give it a try.

if(coalesce(${yourmeasure},0)=0,null,${yourmeasure})

Thanks! It worked 🙂

Top Labels in this Space
Top Solution Authors