Forum Discussion
Visual Alert Gauge
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
Hi Anonymous
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.
7 Replies
Anonymous , 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
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?
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?
Hi Anonymous
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.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.
Again, thanks a lot
Hi Anonymous
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.
