Difference between Plan/Actual in matrix but values are from same column

[Arul]

Hello All,

I have a below requirement where I need to conditionally format the cells of actual values in matrix visual while comparing with plan values. Since the plan/actual values are populating from same column I could not find the difference and add the conditinal formatting in matrix. Please refer the image attached of expected and the data structure.

Thanks,

Arul

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

One of ways to create a solution is to create a measure for conditionally assign the color like below.

Sum measure: = 
SUM(Data[Value])

Conditional format background measure: =
VAR _actual = [Sum measure:]
RETURN
    IF (
        SELECTEDVALUE ( Data[Plan/Actual] ) = "Actual",
        IF (
            _actual
                > CALCULATE ( [Sum measure:], Data[Plan/Actual] = "Plan" ),
            "Light Green",
            "Red"
        )
    )

[Arul]

Thanks @Jihwan_Kim . It's working