Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |