Need to apply specific conditional formatting

[apkmnp]

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:

Best Regards,

Arpit

[Power5]

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]

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