Forum Discussion

elads's avatar
elads
Icon for Helper III rankHelper III
6 years ago
Solved

Row header in different color

Hi,

 

I have three products, for each product I want to give color (Matrix Table)
For example: Product A = Green B=Red C=yellow . 

Is it possible to display the colors of a product in Row Header  (not in values)? 

 

Thanks for the helpers.

 

BR,

Alon

 

  • elads this you can easily achieve by writing a simple measure for color then use background under condtional formatting or store color in a table and get it from there

     

    here is example measure for color to use in background

     

    Color = 
    SWITCH ( 
        MAX ( 'Table (2)'[Slicer] ),
        "A", "Blue",
        "B", "Green",
        "C", "Red",
        "E", "Yellow",
        "Magenta"
    )

     

8 Replies