topic Re: Conditional Formatting using DAX in DAX Commands and Tips

Conditional Formatting using DAX

Balakrishnan_J — Fri, 20 Feb 2026 15:58:16 GMT

Hi Community Members,

I need to use conditional format on matrix with two condition

1. if any three measure falls below threshold value in same month, i need to highlight that value red
2. if any particular measure falls below threshold value for 3 sepearate months in last 1 year, i need to highliht that value red.

Please provide some solution

Re: Conditional Formatting using DAX

cengizhanarslan — Fri, 20 Feb 2026 19:15:17 GMT

1) Rule: “If any 3 measures are below threshold in the same month → highlight”

Any3Below_ThisMonth = VAR t1 = IF( [On Time Delivery %] < [OTD Threshold], 1, 0 ) VAR t2 = IF( [KPI2 %] < [KPI2 Threshold], 1, 0 ) VAR t3 = IF( [KPI3 %] < [KPI3 Threshold], 1, 0 ) RETURN IF( t1 + t2 + t3 >= 3, 1, 0 )

2) Rule: “If this measure is below threshold in 3 different months in last 12 months → highlight”

OTD_BadMonths_Last12 = VAR EndDate = MAX('Date'[Date]) VAR MonthsToCheck = DATESINPERIOD( 'Date'[Date], EndDate, -12, MONTH ) RETURN COUNTROWS( FILTER( SUMMARIZE( MonthsToCheck, 'Date'[YearMonth] ), CALCULATE( [On Time Delivery %] ) < [OTD Threshold] ) )

OTD_3BadMonths_Flag = IF( [OTD_BadMonths_Last12] >= 3, 1, 0 )

3) Final: Color measure for conditional formatting (for OTD)

OTD_CellColor = VAR Rule1 = [Any3Below_ThisMonth] = 1 VAR Rule2 = [OTD_3BadMonths_Flag] = 1 RETURN IF( Rule1 || Rule2, "#FF0000", BLANK() )

Re: Conditional Formatting using DAX

techies — Sat, 21 Feb 2026 09:41:39 GMT

Hi Balakrishnan_J have tested using sample datasets, please review the attached file.

Re: Conditional Formatting using DAX

v-echaithra — Thu, 26 Feb 2026 06:48:21 GMT

Hi Balakrishnan_J ,

Thank you techies , cengizhanarslan for your inputs.

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

Re: Conditional Formatting using DAX

v-echaithra — Mon, 02 Mar 2026 07:39:21 GMT

Hi Balakrishnan_J ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.