Forum Discussion
Notification Repeatedly Triggered by Same Value
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.
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
2 Replies
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