Background color in matrix

[AbbasG]

Hello All,

I have created a custom column in a matrix for the order status.

I need to add a green background color for the ones that are ready to ship.

Any help will be appreciated 🙂

[ribisht17]

Hi Abbas,

Kindly see if it helps

1. Write a DAX expression 

Category Indicator = IF(orders_[Category]="Furniture",1,0)

2. Under Format > Conditional formatting >>Then you can pick the color (green in your case)

Regards,

Ritesh

If this answer helps then please mark it so that it can help others as well

[amitchandak · Accepted solution]

@AbbasG , Create a color measureand use that is conditional formatting using field value option n

Switch(max(Table[Order Status]) ,

"Ready to Ship", "Green",

"Not Ready", "Yellow",

"Red"

)

In matrix you can not use conditional formatting on row/column (pivot) . You can only use on values

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

[AbbasG]

@amitchandak How can I use a different color code here? I tried using hex code but did not work.