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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
salvatore
New Member

radial gauge color

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

6 REPLIES 6
jbgonzalez
Frequent Visitor

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.

Capture.PNG

 

I hope this will help.

 

 

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

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.

ADenson1974_0-1617727508247.png

 

v-chuncz-msft
Community Support
Community Support

@salvatore,

 

You may check the post below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Not applicable

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.