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 guidance in achiving this in the matrix of PBI visual.

 

 

 

Thanks

AP

  • 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.

3 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    Hi Anonymous 

     

    Highlight the visual and go to the Formatting section. Look for Columns, here you will find a number of different formmating options and one of them is background.

     

    You can change the colur of individual columns here. Just change the one you wnat to the colur you want.

     

    Joe

     

    If you found my answer helpful and it solved your issue, please accept as solution

  • Anonymous's avatar
    Anonymous
    Not applicable
    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()
    )