topic Re: Issue with Conditional Formatting in Matrix Visual in DAX Commands and Tips

Issue with Conditional Formatting in Matrix Visual

Anonymous — Mon, 17 Mar 2025 14:33:16 GMT

Hi Team,

Hope you're all doing well.

I was working on applying conditional formatting in the Matrix visual, where I have a column called "ppk" and I am applying the following criteria to achieve color coding using DAX.

Using this DAX (with averages included):

DAX

PPK_Conditional_Color_heatmap = 
VAR Ppk_Value = AVERAGE('PPK'[ppk_vl]) // No COALESCE applied
VAR StdDev_Value = AVERAGE('PPK'[stddev_vl]) // No COALESCE applied
RETURN
SWITCH(
TRUE(),
Ppk_Value = 0 && StdDev_Value = 0, "#808080", // Grey for NULL Ppk & StdDev is Blank
Ppk_Value = 0 && StdDev_Value = 0, "#ADD8E6", // Light Blue for NULL Ppk & StdDev = 0
Ppk_Value >= 1.33, "#69b764", // Green
Ppk_Value >= 1.00 && Ppk_Value < 1.33, "#ffc156", // Yellow
Ppk_Value < 1.00, "#d82526" // Red
)

The criteria for coloring are as follows:

Ppk >= 1.33 → Green
Ppk >= 1.00 && Avg_Ppk < 1.33 → Yellow
Ppk < 1.00 → Red
PPK = NULL & StdDev_Vl = 0 → Light Blue
PPK = NULL & StdDev_Vl = Blank → Grey
However, after applying the formula, the grey and light blue colors are not showing as expected. I believe the issue is that when the cell is empty, the conditional formatting is not triggering. This might be because blank values aren’t being accounted for correctly in the DAX expression.

Has anyone encountered this issue, or do you have any suggestions on how to address it?

Looking forward to your inputs.

Thanks & Regards,
Hk

Re: Issue with Conditional Formatting in Matrix Visual

Deku — Mon, 17 Mar 2025 15:27:23 GMT

try

PPK_Conditional_Color_heatmap = VAR Ppk_Value = AVERAGE('PPK'[ppk_vl]) // No COALESCE applied VAR StdDev_Value = AVERAGE('PPK'[stddev_vl]) // No COALESCE applied RETURN SWITCH( TRUE(), ISBLANK(Ppk_Value) && ISBLANK(StdDev_Value), "#808080", // Grey for NULL Ppk & StdDev is Blank ISBLANK(Ppk_Value) && StdDev_Value = 0, "#ADD8E6", // Light Blue for NULL Ppk & StdDev = 0 Ppk_Value >= 1.33, "#69b764", // Green Ppk_Value >= 1.00 && Ppk_Value < 1.33, "#ffc156", // Yellow Ppk_Value < 1.00, "#d82526" // Red )

Re: Issue with Conditional Formatting in Matrix Visual

Anonymous — Mon, 17 Mar 2025 16:14:21 GMT

Hi Deku ,

Thanks for your response,

I tried but still its coming as previous dax results.

If there are any other solutions, please help me with it.

Thanks in advance!

Re: Issue with Conditional Formatting in Matrix Visual

Pow3Range — Tue, 18 Mar 2025 12:42:39 GMT

Could you please share a PBIX file with sample (non-confidential) data? This will help in understanding the issue better and providing a more accurate solution. You can remove or anonymize any sensitive information before sharing

Re: Issue with Conditional Formatting in Matrix Visual

v-sgandrathi — Tue, 13 May 2025 08:46:52 GMT

Hi Anonymous,

I wanted to check if you had the opportunity to follow up on previous conversation provided by community member. If yes can you please provide the sample data so that we can provide you with the accurate and correct solution.

Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so that other community members can find it easily.

Thank you.

Re: Issue with Conditional Formatting in Matrix Visual

v-sgandrathi — Sun, 18 May 2025 10:50:05 GMT

Hi Anonymous,

As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?

And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.

Your understanding and patience will be appreciated.