Forum Discussion

Randalnik's avatar
Randalnik
Frequent Visitor
9 years ago

Conditional formatting table with text

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.

Need Help

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    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's avatar
      Randalnik
      Frequent Visitor
      9 years ago

      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's avatar
        proj_ss
        Advocate I
        8 years ago

        Hi Rand,

         

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

        Thanks in advance.