cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adanpalma Frequent Visitor
Frequent Visitor

Re: Conditional color formatting - overview

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

 

adanpalma Frequent Visitor
Frequent Visitor

Re: Conditional color formatting - overview

Thanks for your suggestion

 

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

 

Highlighted
agiroux Visitor
Visitor

Re: Conditional color formatting - overview

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: 

image.pngimage.png

praveenvenu Frequent Visitor
Frequent Visitor

Re: Conditional color formatting - overview

Try to see this idea help. https://youtu.be/VIYJ8YM2huQ

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 134 members 1,778 guests
Please welcome our newest community members: