dial guage

[haric]

I was trying a dial guage(custom visual) with the below data points : 

1. Doctor avg.

2. Hospital avg.

3. Provider avg.

4. Minimum value

5. Maximum value

6. Values to define the red, yellow and green sections

Issue:

I am able to plot only Doctor avg. which will be displayed by the pointer and other details like min, max, red, yellow, green

Is there any option to represent multiple metrics (in my case doctor, hospital & provider avg.) in the same gauge ? 

Thanks in Advance.

[v-caliao-msft]

Hi Haric,

Accoridng to your description, you need to display multiple pointers into one dial guage, right?

Based on my research, only one pointers can be displayed on one dial guage. So your requirement is not supported in current version of Power BI desktop. In your scenarion, you need to use three dial guages do diaply doctor, hospital and provider avg separately.

Reference
http://www.cloudfronts.com/power-bi-dialgauge-custom-visual/

Regards,

Chalrie Liao

[samdthompson · Accepted solution]

So how do the red, yellow and green sections work? if we take the red section for instance it will go from minimum value up to where? would it always be hospital or always provider? I ask as this will determin if the dial guage will work. If they are not linear in values then you will get wierd orange green red progressions etc. If the provider say, always has a lower score than the hospital then it would become your next section (orange) and then the hospital (green).

If it just wont work, then you can always make a dial guage in excel with exactly the pointers etc you need and with a bit of if-muckery and pie action you can have the sections etc become dynamic. Then with Powerbi excel addin you can serve the guage up on the dashboard. Not perfect as its not dynamic with the rest of teh dashboard but it is in one place.

[Sean]

@haric Have you tried the Bullet Chart (there's a Download Sample link so you can test it)

https://app.powerbi.com/visuals/show/BulletChart1443347686880