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 li...
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.
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?
