Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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
Memorable Member
Memorable Member

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 Employee
Microsoft Employee

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
Memorable Member
Memorable Member

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.
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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.