Forum Discussion

apkmnp's avatar
apkmnp
Frequent Visitor
2 years ago

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:

 

Best Regards,

Arpit

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      apkmnp
      Frequent Visitor
      2 years ago

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