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

Anonymous,

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


Regards,
Lydia

adanpalma's avatar
adanpalma
New Member
7 years ago

That solution is  good but not enough.  Because the range values are fixed.  My question is   ¡ Is it  posible that the range could be read it from a KPI parameters table  where we can make conditions using  columns instead of fixed values and some other conditions like dates because some KPIs could be green last year but if I change it  with new ranges when I see my dash board I would need to see green last year but may be read this year.  Some thing like

 

 

 

year-month of sales month  >=      KPI.Parameter.Year-MonthValidFrom  and

year-month of sales month  <=      KPI.Parameter.Year-MonthValidTo       and

avg(sales)                            >=      KPI.Parameter.StartRange and

avg(sales)                            <=      KPI.Parameter.EndRange  and

  then 

         KPI.Parameter.colorcode

 

Dou you think that Power BI could have some functionality or some thing like that.  

 

I will appreciate your suggestions or opinion


Thanks