Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to highlight GL Code =80018 back ground color ?

Hi All I cannot get it work , may i know where i go wrong ?    
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi admin11 ,

     

    You can only use measure in this situation. In your sample, your GL Code is in text type because it contains both number value and string value. For text type column in rlues, it only have aggregation of count. 

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

admin11 , Create a new color measure and use that in conditional formatting with field value option

Color GL =
Switch( true(),
max('Table'[GL Code]) = 80081 , "red",
max('Table'[GL Code]) = 80082 , "blue",
"silver"
)