SELECTEDMEASURENAME() and SELECTEDMEASURE() in field type Conditional Formatting

[Maia_LR]

Dear all,

I'm trying to build a measure called [_Colours] that allows to apply a different combination of colours depending on the selected measure I have by using a field type CONDITIONAL FORMATTING and SELECTEMEASURENAME() and SELECTEDMEASURE() functions but it seems that those doesn't works into a conditional formatting: the goal is to avoid to create an specific conditional formatting for each measure.

Any suggestion?

Thank you in advanced

[Maia_LR]

Hi @v-yilong-msft ,

Thanks for your kind reply but this is not exactly what I am asking for: I really know how to link a measure to a conditional formatting but my question was about how to create a dynamic conditional formatting for distinct fields (i.e. % yoy expenses and % yoy incomes) by using a single measure, not several measures, one for each field.

My thinking was using SELECTEDMEASURE() function but as you told me I checked that this functions only works in calculation groups but not in any standard measure.

Thank you anyway.

Best regards

[v-yilong-msft]

Hi @Maia_LR ,

SELECTEDMEASURENAME() and SELECTEDMEASURE() really do not work in conditional formatting.

I created similar tables and conditional formatting.

If you want to differentiate by color I think you can just use the following DAX code.

Colors = 
IF('Table'[Measure]>50,"Green","Red")

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.