Forum Discussion

lotus22's avatar
lotus22
Helper III
5 years ago
Solved

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 pr...
Need Help
  • sanalytics's avatar
    sanalytics
    5 years ago

    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

     

     

sanalytics's avatar
sanalytics
Super User
5 years ago

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