Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm struggling to figure out how to create a measure to conditionally format a matrix. Here's a picture of my matrix:
I"d like to color code all 3 columns under the post group, so that if the value is greater than the corresponding value in the 'Pre' group, then color code green, otherwise color code red
I have my data in a long format rather than wide, so I'm not sure how to go about creating the DAX measure to do this. Here's a sample of it:
Solved! Go to Solution.
Hi @kimchizal,
Please download the demo from the attachment. Please also refer to power-bi/desktop-conditional-table-formatting.
formatMeasure = VAR postValue = CALCULATE ( [Program(s)], FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Post" ) ) VAR preValue = CALCULATE ( [Program(s)], FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Pre" ) ) RETURN IF ( postValue > preValue, 1, 0 )
BTW, please don't share sensitive data here.
Best Regards,
Hi @kimchizal,
Could you please mark the proper answers as solutions?
Best Regards,
Here's a link to the data: removed
Hi @kimchizal,
Please download the demo from the attachment. Please also refer to power-bi/desktop-conditional-table-formatting.
formatMeasure = VAR postValue = CALCULATE ( [Program(s)], FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Post" ) ) VAR preValue = CALCULATE ( [Program(s)], FILTER ( ALL ( Sheet3[prepost] ), Sheet3[prepost] = "Pre" ) ) RETURN IF ( postValue > preValue, 1, 0 )
BTW, please don't share sensitive data here.
Best Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |