Forum Discussion

khopster49's avatar
khopster49
Regular Visitor
4 years ago
Solved

Dax conditional format multiple matrix tables

Hi Guys, Newbie here, just started using Power bi and very green with Dax. 

 

I want to have a conditional background colour on all my matrix. Each matrix has a different headers, but with one consistent colum called Not Compliant.

I want the not compliant colum with a value in them to be "red" ,else blank if no value. 

I was hoping to avoid doing a dax measure for all as I have over 15 of these matrix per page, is there a way to write a measure that i can use in conditional format for each matrix based oon one measure??

The Dax I did for the one above is

Conditional BackgroundColor = IF(MAX('Compliance Report'[CPlan Compliance]) = "Not Compliant", "#E3C2C4", BLANK())
whilst it works im not sure its written well.
 
I hope I have explained this ok?
 
many thanks

 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
     I have over 15 of these matrix per page

    Red flag right there.  Use fewer visuals

     

    And no, you cannot copy conditional formatting between visuals.  What you can do is create one visual, set up conditional formatting, and then copy/paste to new visuals.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago
     I have over 15 of these matrix per page

    Red flag right there.  Use fewer visuals

     

    And no, you cannot copy conditional formatting between visuals.  What you can do is create one visual, set up conditional formatting, and then copy/paste to new visuals.