Forum Discussion

elads's avatar
elads
Helper 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 ...
  • parry2k's avatar
    parry2k
    6 years ago

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