topic Color coding Columns based on a field in DAX Commands and Tips

Color coding Columns based on a field

Anonymous — Thu, 04 Apr 2024 11:35:42 GMT

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

Re: Color coding Columns based on a field

Joe_Barry — Thu, 04 Apr 2024 12:45:25 GMT

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

Re: Color coding Columns based on a field

Anonymous — Fri, 05 Apr 2024 06:49:16 GMT

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.

Re: Color coding Columns based on a field

johnbasha33 — Fri, 05 Apr 2024 09:25:41 GMT

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