topic Re: radial gauge color in Developer

radial gauge color

salvatore — Tue, 07 Aug 2018 16:32:47 GMT

Is it possible to modify the radial gauge to change its color if the target value is greater than the value?

a kind of conditional formatting...

if the value does not reach the target value I would like the color to be red, for example, to highlight a negative delta (gap)

thanks

Re: radial gauge color

v-chuncz-msft — Wed, 08 Aug 2018 09:33:38 GMT

@salvatore,

You may check the post below.

https://community.powerbi.com/t5/Desktop/Gauge-Chart-Conditional-Formatting-colours/td-p/160787

Re: radial gauge color

salvatore — Wed, 08 Aug 2018 10:20:08 GMT

no, unfortunately it is not what I need ... I need to be able to dynamically manage the color of the radial gauge if it is possible

Re: radial gauge color

Anonymous — Wed, 08 Aug 2018 10:49:14 GMT

Unfortunately, Gauge seemed couldn't support dynamically change color to indicate how the value reach the target.

see https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18543640-conditional-color-formatting-for-radial-gauge

but there are several visuals options around the Power BI Marketplace, you can import use Tachometer, which create fraction of each color and see which color the needle (the actual value) would point

or Slim data bar KPI Visual, which the color will be read if below the target, and turned into green if it passed the target

Re: radial gauge color

jbgonzalez — Thu, 22 Aug 2019 20:57:42 GMT

Hi @salvatore

In case you haven't see it yet. Here is a tutorial on how to make the Gauge color dynamic.

https://youtu.be/_JMSw6i5pzY

This feature is almost brand new. From the June Power BI update.

You first create a measure with 'Switch' statement to get the desired color depending on the conditions you need. and then you use this measure in the format tap as show in the following image.

I hope this will help.

Re: radial gauge color

ADenson1974 — Tue, 06 Apr 2021 17:50:30 GMT

It is important to note that you must create measurements from your data so that your Color measurement has measurements to reference. I may have my lines wrong in the image, but it is to get the point across.

Re: radial gauge color

Anonymous — Wed, 27 Apr 2022 20:44:35 GMT

Hi all, Good day! Thanks a lot, @jbgonzalez-I was looking for a Dynamic Gauge color solution. The youtube video shows a simple quick way to define different colors to show up for different values! 🙂