Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

KPI / Gauge indicator help please

Hi, I need to use a gauge with a red/amber/green colour indicator in order to show the following information.  However, I have never used gauges and don't know which one to use, and more importantly have no idea how to use them to show what I want.

 

Unconverted Value

I have a figure that is refreshed daily, and need to identify if that figure is on target i.e.

Green <£250k

Amber £250-349k

Red - £350k plus. 

So, the current figure is £377k and would therefore be Red, as we would want the figure to be below £250k of unconverted revenue in order to be in a good place.

 

The data I have has a row for each client showing how much unconerted revenue there is for that client - I have a 'card' currentlyl that sum's this data up and shows us a running total figure - in an idea world I have have a gauge or a KPI card that changes colour - can someone help me please. 

 

PS: I am very new to Power BI and have never used Pivot tables before so an idiots guide approach would be appreicated.

 

Other data I need is:

 

Cases in Department

Green <300

Amber 300-400 cases

Red 401+

 

Oldest Cases

Green >3 months

Amber 3 to 4 months

Red <4 months

 

Thank you.

Need Help

2 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Anonymous,

    Until now, we can not set the KPI or Gauge visualization color dynamically. The feature request has been submitted here. 

    While, you can use the bar chart to display the value in different colors. I am not sure if it's what you expected. I create the following sample.



    Then create the calculated columns using the formula.

    sum of each clint = CALCULATE(SUM(Table1[Value]),ALLEXCEPT(Table1,Table1[ClientName]))

color = IF(Table1[sum of each clint]<250,"Green",IF(Table1[sum of each clint]<349,"Amber","Red"))


    Finally, create a bar chart, set the bar color based on the color column. You can also create a slicer, when you select one client, the bar chart diaply the total value of the selected client in different color.



    Please download the file, and check if it's helpful for you.

    Best Regards,
    Angelia

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Anonymous,

    Have you resolved your issue? If you have, please mark the right or helpful reply as answer, so more people will benefit from here.

    Best Regards,
    Angelia