Forum Discussion
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...
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.