Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to 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
Proud to be a Super User!
Paul on Linkedin.
@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
Proud to be a Super User!
Paul on Linkedin.
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!!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 60 | |
| 43 | |
| 40 | |
| 36 | |
| 21 |
| User | Count |
|---|---|
| 178 | |
| 122 | |
| 107 | |
| 77 | |
| 50 |