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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi all,
I've got an issue:
I'm using a Table and want to get the numbers in green an %-sign behind those values. How is this possible?
The green numbers are a 'messurement' created via DAX, I've allready tried to add '& "%" ' behind the DAX but no result.
Second question:
I want to get all the values below 80% in red, or that the field is in red.
Tried the conditional formatting but all values are in green.
Many thanks!
Solved! Go to Solution.
Hi @jorismo,
Until now, we can't set the specific color for different colors. Please review this feature request and vote it. Power BI only support gradient color in conditional format, please try the following solution, and check if it works fine.
1. Right click your column wanted to add color->conditional format->font color scales as follows.
2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.
Best Regards,
Angelia
Ok I solved my first question about the %-sign.
But still no sollution found for my value or field conditional formating
Hi @jorismo,
Until now, we can't set the specific color for different colors. Please review this feature request and vote it. Power BI only support gradient color in conditional format, please try the following solution, and check if it works fine.
1. Right click your column wanted to add color->conditional format->font color scales as follows.
2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.
Best Regards,
Angelia
This didn't work for me. My lowest number is .34% and my highest number is 32.32%. I tried all sorts of numerical variations and I only get 1 color no variance. I also tried using the new "Color by Rules" conditional formatting feature - again with tons of variations, but no luck.
Anything else I should try?
Thanks!
Thanks it works great!
Ok I solved my first question about the %-sign.
But still no sollution found for my value or field conditional formating
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.