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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
Power5
Helper IV
Helper IV

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.

apkmnp
Frequent Visitor

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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