Issue with Conditional Formatting in Matrix Visual
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
Extended period chosen?
Hi people, I hope you can help me with a challange: I have a table, which partly looks like this: now, I want to use the "visit date" to choose a period ("from-to" date filter), but I need to see the "calendar dates" and "sale" by date, 5 days before the "visit date"-period starts (MIN visit Date) and 5 days after the period ends (MAX visit date). how do I make this DAX (it is possible to make a calculated table/column as well as a measure)? All help and inspiration is appreciated. Thanks Br, JayJay0306
How to get distinct cumulative Sum of Day wise
Hi Community Member, Please help me to achieve some desired result using power bi dax. Please see the attached details explanation and output we need. See below calculation that we need to convert into power bi dax to achieve output mentioned right side below.
YoY Measurements - Measure to Exclude Clients that don't have data for same period previous year
I have 38 clients, with unique identifier, and as I work to get accurate YoY reporting, I need to exclude clients that came on mid year. For example, say in 2022 I had 5 clients and $1M in sales, and then in 2023 I had 8 clients with $2M in sales, I am not comparing apples to apples. I need to be comparing the same 5 clients from 2022 to the same 5 clients in 2023 (exlcuding the 3 new clients in 2023) in order to get accurate YoY variances for our industry. For the client I do have their start date so could use that as part of the filter or exlcusion data, but from there I am at a loss. Any guidance would be much appreciated.
