Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 u...
  • Burningsuit's avatar
    4 years ago

    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