Dax Conditional formatting

[Anonymous]

Hi,

I've created a field parameter with a set of measures which returns % values. I'd need to get a colour format based on the selected measure. 

I'm trying to get a dynamic colour format using below DAX:

CCcolorFormat =

                SWITCH(

                        TRUE(),

                        SELECTEDMEASURE() >= 0.90, "#00FF00",

                        SELECTEDMEASURE() >= 0.85, "#FFA500",

                        SELECTEDMEASURE() < 0.85, "#FF0000")

I'm not sure where I'm going wrong but the visual doesn't change any colours when using this DAX on the visual. Any help on this would be really appreciated.

Regards,

Mahesh

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file whether it suits your requirement.

[Anonymous]

Hi @Jihwan_Kim ,

I've tried to implement your solution, however, I still don't get the colour format on the KPI visual.

[Jihwan_Kim]

Hi,

Thank you for your feedback.

Could you please share your pbix file's link? And then I can try to look into it to come up with a more accurate solution for your data model.

Thank you.

[Anonymous]

Hi @Jihwan_Kim ,

I really appreciate your help on this. But, I'd be able to share the file as it contains sensitive and confidential data.

I've tried something by making a few changes from my end based on your previous solution and it's working for me.

Thanks a ton for the help!!!!

Regards,

Mahesh