Forum Discussion

SandeepV67's avatar
SandeepV67
Frequent Visitor
3 years ago

Different Background Conditional color formatting in matrix for different rows

I wanted to color each Row with different conditional formatting like shown in the below image , how can I do this in Power Bi Matrix ?? 

 

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    SandeepV67 Maybe try a measure like this and use Rules-based conditional formatting:

    Color Selector Measure =
      VAR __Color = MAX('Table'[Color])
    RETURN
      SWITCH(__Color,
        "Green",1,
        "Yellow",2,
        "Red",3
      )