DAX help for Conditional Formatting

[RanjanThammaiah]

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

[v-luwang-msft]

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

[Samarth_18]

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