Notification Repeatedly Triggered by Same Value

[Anonymous]

Hi there,

I have created a report and dashboard on PowerBI Web designed to trigger a notification when the average price of a product deviates dramatically (+/- 40%). The dataset it is based on updates regularly, so I would like the ability to receive my alert every hour.

However, despite the promise that 'Alerts are only sent if your data changes', this notification is repeatedly tirggered by the exact same value appearing in the tile that it is assigned to:

(note - the value in the example is actually always 0.705381212357567, it's not just that there are minor changes occuring that I can't see).

Has anyone come across this issue before? Is there any way to resolve?

Also I am a first time poster so please let me know if I should be including additional information in my request.

[Burningsuit · Accepted solution]

Hello @Anonymous 

Welcome to the community! Thanks for a clear post setting out your question.

In this case you're reading too much into the alert intelligence.

An alert simply works by arthmetically comparing the value on the visualisation with the threshold value and firing if it is larger (or smaller).

Here you are comparing 0.70538.. with 0.4 so the alert fires because 0.7>0.4=TRUE.

You cannot do anything complex like fire the alert if the value has increased by 40%, you can only compare the value with a constant and fire if it is above or below that constant.

hope this helps.

Stuart

[angryandy]

How ist this the accepted answer? The stated problem was, that the alert was repeatedly sent, even when the value did not change. This problem has not been addressed.