Conditional Formatting for a measure values

Hi Anonymous , 

As per our Understandings you are looking for Background color change on Measure witch if else Condition 

This is My Sample table:

You can achieve this by Creating a column Using Below DAX Expression and using it in Conditional Formatting.

ColorColumn =

var percentageValue = [% Percentage]

var DarkRed =

"#8b0000"

var red =

"#FF0000"

var green =

"#00ff00"

var darkGreen =

"#006600"

return

IF(percentageValue> 0 && percentageValue <

1, DarkRed,IF(percentageValue>1 && percentageValue<5, red,IF(percentageValue>5

 && percentageValue <45 , green,IF(percentageValue>45,darkGreen))))

Now Just use this color Column in conditional Formatting

Choose the Colour Column :

This will give below result:

If possible you can provide us a sample pbix report with your data structure, so we can check and help you to achieve this in your report as well.

If this answer helps, please mark it as Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at [email protected]

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/