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

show red yellow green gauge from low to high

I need a gauge to show from low to high as green is measured as < 0.5%, yellow is 0.51% to 1% and red is > 1%. 


All the gauges seem to be designed to show Green as reaching the maximum. So far, the only workaround has been to create gauges using 1-the metric to show opposite metric.

 

Any suggestions?

 

Thanks, Ben

6 REPLIES 6
Highlighted
benjenkinsiv Frequent Visitor
Frequent Visitor

show red yellow green gauge from low to high

I need a gauge to show from low to high as green is measured as < 0.5%, yellow is 0.51% to 1% and red is > 1%. 


All the gauges seem to be designed to show Green as reaching the maximum. So far, the only workaround has been to create gauges using 1-the metric to show opposite metric.

 

Any suggestions?

 

Thanks, Ben

Super User
Super User

Re: show red yellow green gauge from low to high

Have you checked out DialGauge?

 

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

 


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-caliao-msft
Moderator

Re: show red yellow green gauge from low to high

Hi Ben,

 

According to your description, the Gauage does not suffice the requirement for you. As Smoupre said, Power BI team have published the DialGauge custom visual and currently it is available for Power BI users to download. Here are some details about how to set the options in DialGauge custom visual.

 

  • Colour indicated by red displays actual value.
  • Colour indicated by yellow displays target value.
  • Pointer displays any value.
  • Null/blank/max values will be indicated by colour green.
  • Default minimum value is 0.
  • Default maximum value is 100.
  • Additional label to display value. It append % sign.
  • Name of chart will be displayed on Center of Dial Gauge.

 

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


Have you tried this custom visual? If this is not what you want, please elaborate your requirement, so that we can make further analysis.

 

Regards,

benjenkinsiv Frequent Visitor
Frequent Visitor

Re: show red yellow green gauge from low to high

Yes, I've tried it. I'm unable to accomplish my requirements with it either. 

 

I've created 3 requests with the cloudfronts team as well. 

 

With it and any other gauge, I'm unable show Green to Red from low to high. That is, my Green range is 0-.5%, Yellow is 0.5-1% and Red is > 1%. 

 

Thanks, Ben

benjenkinsiv Frequent Visitor
Frequent Visitor

Re: show red yellow green gauge from low to high

Yes, I've tried it but haven't been able to get it to do what I need. 

 

Thanks, Ben

benjenkinsiv Frequent Visitor
Frequent Visitor

Re: show red yellow green gauge from low to high

I've now been able to get the bullet chart to work by changing Very Good Color to Red, Good to Yellow and Satisfactory to Green. It would still be nice to see this as default behavior of the various graphs. The bullet chart is described with this behavior here: Bullet Graphs for Not-to-Exceed Targets


Thanks, Ben

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)