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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

IF conditional formating with 2 condition

Delion_0-1613706876625.png

Hi

How to create DAX IF for conditional formating with 2 categories

I tried this but give error

 

KPI_Points = IF((SUM(Sales[Points] ) && Sales[WO_Type] ) < (SUM(KPI[Points]) && KPI[[WO_Type] ) ,"Red","Black")

 

Thank

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , if conditions are wring they need to be like the example

 


KPI_Points = IF(SUM(Sales[Points] ) <100 && KPI[[WO_Type] = "A" ,"Red","Black")

 

Change as per need.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.