Forum Discussion

David23's avatar
David23
Frequent Visitor
3 years ago
Solved

Alternate matrix row colors

Hello I work with Power Bi Desktop RS. I want a dynamic background color. I explain myself with the image below: I want the lines of area 1, 3 and 5 to be with a red background color. and the li...
Need Help
1Daniel993's avatar
1Daniel993
Icon for Helper III rankHelper III
3 years ago

Hello you need go to the field select the Conditional background and in Format style Select Rules, and just put your requirements

 

Regards

David23's avatar
David23
Frequent Visitor
3 years ago

I just wish alternate matrix row colors .
 Conditional background does not allow colors to be alternated.

  • 1Daniel993's avatar
    1Daniel993
    Icon for Helper III rankHelper III
    3 years ago

    Can you send us one example that you want in excel?

    • David23's avatar
      David23
      Frequent Visitor
      3 years ago

      i want have dynamique alternate matrix row colors (orange/blue) like this :

       

       

      • PaulDBrown's avatar
        PaulDBrown
        Icon for Community Champion rankCommunity Champion
        3 years ago

        At present, you cannot conditional format row headers. So this is the closest I've got:

        Using a measure for the conditional formatting (& manual formatting of column and row totals) along the lines of:

        CF =
IF (
    NOT ISINSCOPE ( Data[Pr offer] ),
    "White",
    IF (
        NOT ISINSCOPE ( Data[Year - Month] ),
        "White",
        IF (
            SELECTEDVALUE ( Data[Pr offer] )
                IN { "Bi & Data", "Business Consulting", "Infrastructure" },
            "#EFB5B9",
            "#A0D1FF"
        )
    )
)