Color Coding only the blank()

[RanjanThammaiah]

HI All,

i just wanted to color coding the middle row of the table where the intersect of both the column(Marked in Orange Line).

IF(SELECTEDVALUE(SSL[SSL])=SELECTEDVALUE('Comparision SSL'[SSL_Copy]),

BLANK(),

[Anonymous]

Hi @RanjanThammaiah ,

is this what you want?

Aiolos Zhao

[RanjanThammaiah]

@Anonymous  thanks,

But it does affect the other blank columns as well.

[Anonymous · Accepted solution]

Hi @RanjanThammaiah ,

I have a workaround to do this, for example, you set these values of these cells to 9999.

Then you can use the font color in conditional formatting to set the color to white.

And then set the background to red color for example.

Is that ok with you?

Aiolos Zhao

[amitchandak]

@RanjanThammaiah , I doubt having an option to color blank. The workaround it add +0 in measure and color 0, but that will add all dimension member in scope