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

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User

        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"
        )

         

  • aamnb7's avatar
    aamnb7
    Frequent Visitor

    Hola,

    ¿Alguien pudo realizar esto?