Forum Discussion
Conditional Statement in Matrix table
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.
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
2 Replies
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-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-valuesCreate 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
