Conditionally Format Column in Matrix Based on Color Mapping Measure

[MichaelaMul]

Hi,

I have multiple segment names that I would like to color code based on the name in a matrix. I made the following measure but it isn't working. Any suggestions?

Segment Name ColorMapping = 

    SWITCH(TRUE(),

        VALUES(UPCData[Segment Name]) = "Other Nut Plant Based VAM", "#EC8FCA", 
        VALUES(UPCData[Segment Name]) = "Other Non-Nut Plant Based VAM", "#A1343C",
        VALUES(UPCData[Segment Name]) = "Almond Milk", "#41A4FF",  
		VALUES(UPCData[Segment Name]) = "Coconut VAM", "#9071CE",  
		VALUES(UPCData[Segment Name]) = "Oat Milk", "#AD5129",  
		VALUES(UPCData[Segment Name]) = "Rice VAM", "#850757",  
		VALUES(UPCData[Segment Name]) = "Soy VAM", "#7AC541", 
		VALUES(UPCData[Segment Name]) = "Almond Aseptic", "#118DFF", 
		VALUES(UPCData[Segment Name]) = "Cashew Aseptic", "#DF572A",  
		VALUES(UPCData[Segment Name]) = "Oat Aseptic", "#EB895F",
		VALUES(UPCData[Segment Name]) = "Coconut Aseptic", "#AC95DA", 
		VALUES(UPCData[Segment Name]) = "Rice Aseptic", "#702254",  
		VALUES(UPCData[Segment Name]) = "Soy Aseptic", "#A38600",  
	
        BLANK() 

    )

[MichaelaMul · Accepted solution]

Nevermind! I fixed it- I changed it so that it was the MAX of the Segment Name so the fixed measure is below:

SWITCH(TRUE(),

        MAX(UPCData[Segment Name]) = "Other Nut Plant Based VAM", "#EC8FCA", 
        MAX(UPCData[Segment Name]) = "Other Non-Nut Plant Based VAM", "#A1343C",
        MAX(UPCData[Segment Name]) = "Almond Milk", "#41A4FF",  
		MAX(UPCData[Segment Name]) = "Coconut VAM", "#9071CE",  
		MAX(UPCData[Segment Name]) = "Oat Milk", "#AD5129",  
		MAX(UPCData[Segment Name]) = "Rice VAM", "#850757",  
		MAX(UPCData[Segment Name]) = "Soy VAM", "#7AC541", 
		MAX(UPCData[Segment Name]) = "Almond Aseptic", "#118DFF", 
		MAX(UPCData[Segment Name]) = "Cashew Aseptic", "#DF572A",  
		MAX(UPCData[Segment Name]) = "Oat Aseptic", "#EB895F",
		MAX(UPCData[Segment Name]) = "Coconut Aseptic", "#AC95DA", 
		MAX(UPCData[Segment Name]) = "Rice Aseptic", "#702254",  
		MAX(UPCData[Segment Name]) = "Soy Aseptic", "#A38600",  
		MAX(UPCData[Segment Name]) = "Other Nut Plant Based Aseptic", "#0E1A77", 
		MAX(UPCData[Segment Name]) = "Other Plant Based Aseptic", "#D00A77",
		MAX(UPCData[Segment Name]) = "Barista Aseptic", "#A8337D",
		MAX(UPCData[Segment Name]) = "Digestive Milk", "#70BBFF", 
		MAX(UPCData[Segment Name]) = "Almond & Oat Creamer", "#E1C233",  
		MAX(UPCData[Segment Name]) = "Non Dairy Ice Cream", "#50005C", 
		MAX(UPCData[Segment Name]) = "Traditional Ice Cream", "#D64550",  
		MAX(UPCData[Segment Name]) = "Large Curd CC", "#092F55",  
		MAX(UPCData[Segment Name]) = "Medium Curd CC", "#5E1BE1",  
		MAX(UPCData[Segment Name]) = "Whipped Curd CC", "#DE6A73", 
		MAX(UPCData[Segment Name]) = "Deli Dip", "##893395",  
		MAX(UPCData[Segment Name]) = "Rfg Dairy Dip", "#E1C233", 
		MAX(UPCData[Segment Name]) = "Produce Dip", "#0C6F2B",  
		MAX(UPCData[Segment Name]) = "Enhanced Milk", "#0DFADB",
		MAX(UPCData[Segment Name]) = "Flavored Milk and Shakes", "#DE07D3", 
		MAX(UPCData[Segment Name]) = "Lactose Reduced Milk", "#0E1A77",  
		MAX(UPCData[Segment Name]) = "Organic Milk", "#0DD20A", 
		MAX(UPCData[Segment Name]) = "Other Specialty Milk", "#F2C605", 
       BLANK() 

    )

[Anonymous]

Hi @MichaelaMul,

Congratulations on solving this issue and thanks for sharing your solution.

It will do great help to those who meet the similar question in this forum.

Thanks again for your contribution.