Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
jorismo
Helper II
Helper II

Monthly Percent in a Table and conditional formating

Hi all,

 

I've got an issue:

Screenshot_2.png

 

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!

1 ACCEPTED 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.

1.PNG

2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.

2.PNG3.png
Best Regards,
Angelia

View solution in original post

5 REPLIES 5
jorismo
Helper II
Helper II

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.

1.PNG

2. Type the 0.80 as minimum and 0.81 as maximum, you will the close result.

2.PNG3.png
Best Regards,
Angelia

Anonymous
Not applicable

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!

 

jorismo
Helper II
Helper II

Ok I solved my first question about the %-sign.

 

But still no sollution found for my value or field conditional formating

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors