cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimchizal Regular Visitor
Regular Visitor

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:

pbi.PNG

 

 

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:

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Creating a measure to conditionally format a matrix

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 )

Creating-a-measure-to-conditionally-format-a-matrix

 

 

BTW, please don't share sensitive data here.

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
kimchizal Regular Visitor
Regular Visitor

Re: Creating a measure to conditionally format a matrix

Here's a link to the data: removed

Community Support Team
Community Support Team

Re: Creating a measure to conditionally format a matrix

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 )

Creating-a-measure-to-conditionally-format-a-matrix

 

 

BTW, please don't share sensitive data here.

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: Creating a measure to conditionally format a matrix

Hi @kimchizal,

 

Could you please mark the proper answers as solutions?

 

 

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.