Forum Discussion

DJBAJG's avatar
DJBAJG
Icon for Helper IV rankHelper IV
4 years ago

Conditional Formatting.... Maybe???

Hi Team   I've got a question that, as you can see based on my title, may indeed be answered by using conditional formatting but I'm not sure as I haven't been able to get it to work. What I'm atte...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

DJBAJG , Create a measure like , hope Id is used in visual

 

Switch(true() ,

left(max(Table[ID]) ,5) = "6D5A0" , "Green" ,

"White"

)

 

Use in conditional formatting using field value option 

DJBAJG's avatar
DJBAJG
Icon for Helper IV rankHelper IV
4 years ago

Hi amitchandak

 

Thanks for the quick reply. Perhaps I didn't give enough detail. The solution must by dynamic. Any and all IDs that appear in matrix 1 and matrix 2 must be highlighted. A hard-coded measure will not achieve that.

Thanks.

  • DJBAJG's avatar
    DJBAJG
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi Team

     

    Still looking for some help on this one. Any suggestions or advice are appreciated.

     

    Thanks. 

    • DJBAJG's avatar
      DJBAJG
      Icon for Helper IV rankHelper IV
      4 years ago

      Anyone got any ideas? 

      • DJBAJG's avatar
        DJBAJG
        Icon for Helper IV rankHelper IV
        4 years ago

        Happy Monday. Still struggling with this one...