DAX Conditional Formtting - Color based on Number "is Between" two values?

[Anonymous]

Hi there! I must be missing something simple here.

I'm using this DAX to set the color on the "Cover Weeks" column in this matrix.
v

This is not working quite right, I want values 4, 5, or 6 to be yellow if the "Current Cover (Weeks)" measure,  I can't understand why the above still colors a 3 as yellow?

Any help much appreciated!

Thanks

Alex

[Anonymous]

HI @Anonymous,

Can you please share some dummy data with your measure formula to test?

How to Get Your Question Answered Quickly
Regards,

Xiaoxin Sheng

[Anonymous]

Conditional Fomartting for a particular field can be done graphically using  Conditiona Formatting --> Background color as well. Please find the below screenshot for the same.

[amitchandak]

@Anonymous , Merge second and third using && in

<=6 , should be <=6 &&