Visual Alert Gauge

[EricHHA]

Hello all,

I'd like to show some kind of visual alert on the Gauge when it exceeds the limit of the budget. 

Below, there is an example of it. The amount already used is 298K and the budget's limit is 160K.

I searched trough the web but couldn't find anything specific for this type of gauge.

Thanks in advance

https://imgur.com/dPwXzm8

[EricHHA]

Thank you for the replies, but I still did not find any kind of "alert" within the view. As mentioned, I did put the budget on target value, but it simply added a slash on the gauge. What I really want to show is something like the image below, some kind of "!" red sign showing that the max value has been reached.

https://imgur.com/ZE1Xdl9

Again, thanks a lot

[v-juanli-msft · Accepted solution]

Hi @EricHHA 

This is a kpi visual, please see how to create this visual:

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi

By default, the Gauge visual doesn't show that "!" sign.

Or we may work with some workarounds:

1. conditional formatting

https://radacad.com/sentiment-colors-for-gauge-visual-in-power-bi

Measure

color = IF(SUM('Table'[value])>SUM('Table'[goal]),1,0)

2.

Or add a card visual

Measure = IF(SUM('Table'[value])>SUM('Table'[goal]),"!"," ")

Turn off "border" for card visual.

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

[EricHHA]

Hi Maggie,

Thanks a lot for the support! Really appreciate it.

[v-juanli-msft]

Hi @EricHHA 

As checked, their answers all seems to be helpful.

There are some Gauge visuals you could use in Power BI.

https://visualbi.com/blogs/microsoft/powerbi/custom-visuals/5-advanced-gauge-customization-power-bi/

Also, you could also add alerts in Power BI Service so Power BI can sends notifications to you and your members when the data exceeds the limit.

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-alerts

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

[vanessafvg]

if you put a budget value on the goal and spending on the value you should show

you can play with the most settings to get a better view, is that what you're looking for?

[vanessafvg]

if you put a budget value in the target and the spend in the value it should show

you can play with settings more to get a better view, is that what you looking for?

[amitchandak]

@EricHHA , you can create one and pud that in card visual and group the with Guage visual

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-radial-gauge-charts

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-visuals