Forum Discussion
BIswajit_Das
Impactful Individual
Impactful IndividualDAX MODIFICATION
There are three measures to set color for a column in a table visual i.e 1) SUB1_EP_COLOR = VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP]) RETURN IF(LEFT(_sub1,1) = "...
ValtteriN
Community Champion
Community ChampionHi,
It is a bit unclear what your goal is but for now I will assume the following:
1. You have multiple slicers that you want to determine your color
2. The measure should work with multiple measures
Dax:
Color combination switch =
var _color1 = MAX('Color1'[Color1])
var _color2 = MAX('Color2'[Color2])
var _color3 =MAX('Color3'[Color3])
return
SWITCH(_color1&_color2&_color3,
"AAA","#fcdc9c",
"AAB","#9df2d1",
"AAC","#95bcf5",
"ABA","#fcdc9c",
"ACA","#9df2d1",
"ABB","#95bcf5") //Continue the logic
This measure will return a color based on the state of the 3 slicers.
E.g.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/