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
8 years ago

Thanks but how can I change the range...like if I want it specifically 0-10% RED, 11%-50% black, 51%-100% green? I don't see anywhere to change the ranges for each color. Thanks.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This is exactly what I want but I do not see this selection for KPIs. What visualization are you using? 

 

Thanks for the help,

 

Z

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    That is a Table visualization.

    • parry2k's avatar
      parry2k
      Super User
      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.