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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
EricHHA
Helper II
Helper II

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

https://imgur.com/dPwXzm8

 

1 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)

Capture4.JPGCapture5.JPG

2.

Or add a card visual

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

Capture6.JPG

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.

View solution in original post

7 REPLIES 7
EricHHA
Helper II
Helper II

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

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)

Capture4.JPGCapture5.JPG

2.

Or add a card visual

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

Capture6.JPG

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.

Hi Maggie,

 

Thanks a lot for the support! Really appreciate it.

v-juanli-msft
Community Support
Community Support

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
Super User
Super User

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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




vanessafvg
Super User
Super User

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 I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




amitchandak
Super User
Super User

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.