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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
apkmnp
Frequent Visitor

Need to apply specific conditional formatting

Hi Team,

 

I have come across a new requirement on conditional formatting across PowerBI table where in case the KPI>=100%, the cell color should be green while on KPI% being varied from 0 to 99.99%, the gradient of red to yellow should follow. 

The best solution which I could think of is to use a measure to identify some intervals from 0-99.99% to classify for different shades of red and yellow while with >100% as green but again this won't be providing a close enought impact to the gradient.

 

Any other ideas to figure this out? Sample data set as below:

apkmnp_0-1700227463796.png

 

Best Regards,

Arpit

2 REPLIES 2
Anonymous
Not applicable

Did you try conditional formatting? Under visualizations pane where you insert the columns in the table select the down arrow - conditional formatting - gradient rules. 

 

From there, enter your rules.

Hi, I need to use both rule and gradient in a single column formatting. These are two seperate options in current PowerBI setup

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.