color cells with blank value in a matrix

[Giada_Togliatti]

Hi,

I have a matrix with some blank value, I need to color blank value in red and other value in green.

I tried some formulas using isblank but they doesn't work.

How can I do?

Thank you

[Fowmy · Accepted solution]

@Giada_Togliatti 

Make sure you have blanks in the resulting measure. Select the value and apply the background CF as below.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Giada_Togliatti , You can add +0 and then try I doubt you will able to color blank 

or try a color measure

if(isblank([meausre]) , "Red", "Green")

And use that is conditional formatting with "Field value" option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values