Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
4 years ago

DAX help for Conditional Formatting

Hi All,

 

Can someone help in correcting the below DAX.

I am trying to add conditional formatting based on the below DAX which has different Groups and has to meet 2 different conditions.

It's working but it applies only for MS SL group.

Color =
SWITCH (SELECTEDVALUE(Scorecard[Group]), "ACCELERATE","Innovate & Build","Market Segment","Protect",
SWITCH( TRUE(),SUM(Scorecard[Total Score])>50,"ColoredArrowDown",
Sum(Scorecard[Total Score])>40,"ColoredArrowRight",
"ColoredArrowUp"),
"Industry","MS SL", SWITCH( TRUE(),SUM(Scorecard[Total Score])>40,"ColoredArrowDown",
Sum(Scorecard[Total Score])>32,"ColoredArrowRight",
"ColoredArrowUp"))
 

 

Need Help
Show and Tell

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi RanjanThammaiah ,

     

    Please try this:-

    Color =
SWITCH (
    SELECTEDVALUE ( Scorecard[Group] ),
    "ACCELERATE" || "Innovate & Build"
        || "Market Segment"
        || "Protect",
        SWITCH (
            TRUE (),
            SUM ( Scorecard[Total Score] ) > 50, "ColoredArrowDown",
            SUM ( Scorecard[Total Score] ) > 40, "ColoredArrowRight",
            "ColoredArrowUp"
        ),
    "Industry" || "MS SL",
        SWITCH (
            TRUE (),
            SUM ( Scorecard[Total Score] ) > 40, "ColoredArrowDown",
            SUM ( Scorecard[Total Score] ) > 32, "ColoredArrowRight",
            "ColoredArrowUp"
        )
)

     

    Thanks,

    Samarth

     

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    HI RanjanThammaiah ,


    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

    Best Regards
    Lucien