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 way to create a dynamic legend, please share. See attached.

I had to create a measure using a dax to calculate number of 'Yes' and 'No' so the percents in each row would highlight by correctly according to my range values.

 

Percent and color code values: Red '#FF0D0D' (0-85%) Yellow '#FFFB0D' (85-90%) Green '#12EA2B'(91-100%).

 

The conditional formatting rule is based on the percent of YES measure.  

 

See DAX Measure below that was used to calculate percent of 'Yes' & 'No' in response column. Now I need to make a legend to reflect conditional formatting colors, preferably dynamic if possible. 

 

DAX Measure 

Percent of Respondent ID for Yes =
VAR _YESCount
=
CALCULATE(
    DISTINCTCOUNT('Sheet'[Respondent ID]),
    'Sheet'[Audit Elements Responses] IN { "Yes" }
)
VAR _PerYESCount
=
CALCULATE(
    _YESCount/
    DISTINCTCOUNT('Sheet'[Respondent ID])
)
RETURN
_PerYESCount

 

 

Need Help
Tips and Tricks

3 Replies

  • 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.