cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

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

3.PNG

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

3 REPLIES 3
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

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.

 

swathi_20_1-1615982942746.png

 

 

amitchandak
Super User
Super User

@Anonymous , Merge second and third using && in

<=6 , should be <=6 &&

Helpful resources

Announcements
Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors