Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Color coding Columns based on a field

Hello, I need to color code columns[QTD,YTD,Base Revenue& Total] for product as END POINTs and SAAS (same columns but deferentiated based on product).   Below is what I am expecting.   Need guida...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    You can apply the following formula to conditional formatting, see below:

    M_ =
SWITCH (
    SELECTEDVALUE ( 'Table'[Product] ),
    "END POINTS", "Yellow",
    "SAAS", "green"
)

     

    Best Regards,
    Adamk Kong

     

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

johnbasha33's avatar
johnbasha33
Icon for Super User rankSuper User
2 years ago

Anonymous 
ProductCategory =
SWITCH(TRUE(),
'YourTableName'[Product] = "END POINTs", "END POINTs",
'YourTableName'[Product] = "SAAS", "SAAS",
BLANK()
)