change display for missing values in a pivot table

[mstoler]

Hello,

I get alot of requests to change the values for missing data (- with grey background) to just display either 0 or a white background.

Is there anything new that can address this below?

Thank You,

Michael

[tm_burgers · Accepted solution]

@ChristofSchwarz  just posted last month about this exact thing on his YouTube channel

https://youtu.be/9lhL3Nrel5Q

You can use the Styling section of the MultiKPI object to hide the grey and the dash!

.cell.ng-scope.null-value {background-color:rgba(0,0,255,0); color: rgba(0,0,0,0); font-size:0px;}

[Kashyap_R · Accepted solution]

Hi

Try using isnull function in the expression and replace with it 0

thanks

[mstoler]

I did try that but the problem is there is no data in the pivot table so it never gets evaluated.

Michael

[mstoler]

This is brillant!

Thanks,

Michael

[colinodonnel]

Can this also apply to grey out zero values (e.g. 0.0)?

[tm_burgers]

you could likely write in your measure formula to display the value null if it = 0?

[colinodonnel]

thats an option.

However i would prefer if I could apply styling to the entire sheet (and all its objects) in one go.

This can be done with CSS for Null-values per the youtube clip