Show "-" as 0 and consider in color coding in pivot table

[agni_gold]

Hi All,

I have one pivot table , but i am getting some "-" values there . but i want to show them as 0 and want to color as well based on condition.

Can it be possible ?

[Thiago_Justen_]

Maybe this will be helpful.

Into your load script you can do something like this:

If(IsNull(Diseases),0,Num(Diseases)) as Diseases

Then in UI you can put this expression,for instance, to text color:

If(Your_Measure=0,Yellow())

But, if instead this you want to do this only in the UI, maybe you should try this out:

If(IsNull(Diseases),0,Num(Diseases))

Cheers