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...
Need Help
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.