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
Super User
2 years ago

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