Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Maheshguptaz
Helper II
Helper II

Dax Conditional formatting

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
1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1662968977201.png

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

4 REPLIES 4
Jihwan_Kim
Super User
Super User

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.

 

Jihwan_Kim_0-1662968977201.png

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


Hi @Jihwan_Kim ,

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

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.

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.