Forum Discussion
Conditional Formatting did not show Color Background based on Rule set
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
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
2 Replies
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
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!!
