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

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.