radial gauge color

[salvatore]

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

[jbgonzalez]

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.

[sohananahid]

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! 🙂

[ADenson1974]

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.

[v-chuncz-msft]

@salvatore,

You may check the post below.

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

[salvatore]

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

[Anonymous · Accepted solution]

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-format...

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