Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors