Conditional Statement in Matrix table

[lotus22]

I am having issues creating conditional formating in Matrix table

I want to highlight the rows where Actual is more than Budget. I may be using the wrong visual. is there an other visual that can provide similar or better information.

[sanalytics · Accepted solution]

@lotus22 

Create the Color measure like this

Then go to the Format section -> Conditional formatting -> on Background color ->Advanced Control -> Select Field Value in Format By Section --> on the Based on field , select Color measure.

Attached is the pbix file.

https://dropfiles.org/8F6LLk8Q

Hope it will help

Regards,

Sanalytics

if it is your solution then please accept it as solution and appreciate for kudos

[amitchandak]

@lotus22 , For this better to create two measures ,

actual = sumx(filter([Type]="Actual"),[USD])

Budget= sumx(filter([Type]="Budget"),[USD])

create a color measure

color = if([actual] >[budget],"green", "white")

Use that in conditional formatting using field values option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values