cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
haric
New Member

dial guage

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.

 

1 ACCEPTED SOLUTION
samdthompson
Super User
Super User

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.

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

3 REPLIES 3
v-caliao-msft
Microsoft
Microsoft

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
Super User
Super User

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.

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

Sean
Community Champion
Community Champion

@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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors