Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional color formatting - overview

New to Power BI and it seems like there is no real way to do any dynamic color formatting based on a condition.   So if I just want to have my KPI be red if below a certain value and green if above...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    Using conditional formatting feature in Power BI Desktop, you can achieve your requirement. Please review the following screenshots.


    Regards,
    Lydia

  • parry2k's avatar
    parry2k
    8 years ago

    Standard KPI doesn't allow you to give the range, you have to probably look for custom KPI visual , here is link to KPI with lot of customization you can do with it.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

I'm new on this forum and I hope I'm on the good topic.

 

I really like Power BI and I would like to show to my team that we should move to Power BI for daily, weely and monthly KPI instead of excel. But we have strict standard for the visual interface for our KPI.

 

Could you let me know if there is a feature in Power BI to respect the criterias below ? Standard graph or a safe custom one (something official)?

 

Thank you!

 

Our KPI shall:

  1. Data value (count) : Bars
  2. Objective : Straight line
  3. If value is lower than objective , the bars shall be red
  4. If value is higher than objective, the bars shall be green 
  5. Could be also the other way : lower than objective : green and higher than objective : red

ex: