Forum Discussion

erikoos's avatar
erikoos
Frequent Visitor
2 years ago

Conditional Formatting Slicer?

Hi, can anyone assist in creating a measure or calculated column I can use to make a conditional formatting dynamic legend slicer along with steps to use measure as a slicer? Or if there is another...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi erikoos ,

Please try to create a measure with below dax formula:

Measure =
VAR _a = [Percent of Respondent ID for Yes]
VAR _result =
    SWITCH (
        TRUE (),
        _a < 0.85, "red",
        _a >= 0.85
            && _a <= 0.9, "yellow",
        _a >= 0.91
            && _a <= 1, "green"
    )
RETURN
    _result

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.