Dar formato condicional a la columna de la matriz en función de la medida de asignación de colores

[Syndicate_Admin]

Hola

Tengo varios nombres de segmentos que me gustaría codificar por colores en función del nombre de una matriz. Hice la siguiente medida pero no funciona. ¿Alguna sugerencia?

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

    )

[Syndicate_Admin · Accepted solution]

¡No importa! Lo arreglé, lo cambié para que fuera el MAX del nombre del segmento, por lo que la medida fija está a continuación:

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

    )

[Syndicate_Admin]

Hola @MichaelaMul,

Felicitaciones por resolver este problema y gracias por compartir su solución.

Será de gran ayuda para aquellos que se encuentren con la misma pregunta en este foro.

Gracias de nuevo por tu contribución.