Conditional formatting table with text

[Randalnik]

Hello everyone,

I have searched for the similar topics here and I found just bad news.

I'm looking for conditional formating text in table (i know, numbers shoul be formated).
I have 12 columns with values in (Y , N) and i would like to format it:

If its Y = GREEN

If its N = RED

Is there any chance how to solve this problem (i think there should be way with precast into true/false but i don't know how to do this quickly and easily) ?

But in origin report customer wants to see values Y and N and not TRUE/FALSE or 0/1.

Thank you and have a nice day,

R.

[v-sihou-msft]

@Randalnik

Currently, Power BI Desktop doesn't support this kind of precast or based on other field value to configure conditional formatting. Please submit a feature request on idea.

Regards,

[Randalnik]

@v-sihou-msft

After all, if I change Y to 1 and N to -1 (due to different color) and use condition formatting - Color scales.
Is it possible to make a column mask which set back the values (N,Y) and let there colors of the previous formatting?

If its possible, should someone help me with the DAX syntax?

Thanks a lot, have a nice day,

R.

[proj_ss]

Hi Rand,

Did you get the solution for the above problem. If yes, Please let me know.

Thanks in advance.