Forum Discussion
Creating a measure to conditionally format a matrix
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:
Hi Anonymous,
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,
3 Replies
Hi Anonymous,
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 Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,