Color coding Columns based on a field

[Anupal]

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

[johnbasha33]

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

[Anonymous · Accepted solution]

Hi @Anupal ,

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.

[Joe_Barry]

Hi @Anupal 

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