Conditional Formatting did not show Color Background based on Rule set

[Anonymous]

Dear all, 

I would like to make a conditional formatting on background based on percentage of Total Data, as below:

But the background color did not show as expected. 

Even 7, with percentage of 2.8% are showing darker red when it should be light red. Is there anyway i can make the visualization align with the color coding?

Thank you 

[PaulDBrown · Accepted solution]

@Anonymous 

The values in your visual are whole numbers (not percentages). So try changing the expression to "Number" (instead of "Percent") in the conditional formatting expressions

If you want to format based on a percentage, you need to include the % measure in the visual instead of the whole number

[Jihwan_Kim]

Hi, @Anonymous 

One of the reasons might be in case you selected the wrong measure.

Or, please share the sample pbix file, then I can try to have a look.

Thank you.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!