Forum Discussion
Formatting Background Color Conditional - Blank, Null, Empty, Zero?
Anonymous , with Range I doubt, but with Measure color and use that in conditional formatting with field value option
Switch( true() ,
isblank([measure]) , "red" ,
[measure] =0 , "Yellow" ,
[measure] <10 , "Orange",
"green"
)
refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4
Anonymous , Create a measure
New measure = [measure] +0
And use this measure in coditional formatting
I think in that case if should pickup 0 .
0 can be an acceptable and scorable value from the measure so I want it to actually format the empty value as a blank like it indicates it will in the settings.
Anonymous , with Range I doubt, but with Measure color and use that in conditional formatting with field value option
Switch( true() ,
isblank([measure]) , "red" ,
[measure] =0 , "Yellow" ,
[measure] <10 , "Orange",
"green"
)
refer
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://www.youtube.com/watch?v=RqBb5eBf_I4Hi Anonymous ，
Could you pls some sample data,or if possible ,your .pbix file would be better for us to test?
Remember to remove the confidential information.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
Sampl;e data is not necessary. Just read slower. Pretty simple use case.
