Forum Discussion

BIswajit_Das's avatar
BIswajit_Das
Impactful Individual
3 years ago

DAX 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) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

2) SUB2_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB2_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))

3) SUB1_EP_COLOR =
VAR _sub1 = SELECTEDVALUE('Z_EP_DATA'[#WINNING%GAP_WITH_BO_PARTY_SUB1_EP])
RETURN
IF(LEFT(_sub1,1) = "B","#fcdc9c",IF(LEFT(_sub1,1) = "I","#9df2d1",IF(LEFT(_sub1,1) = "J","#95bcf5",IF(LEFT(_sub1,1) = "O","#fabee0"))))
Needed measure is a single measure
which can work on multiple selected values for multiple measures
Thanks

1 Reply

  • ValtteriN's avatar
    ValtteriN
    Community Champion
    3 years ago

    Hi,

    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/