Forum Discussion
Setting alert
Hey guys,
I have a question.
I have a huge dataset which includes the parcels, waiting time and couriers.
I want to create an alert if the parcel is waiting over three days.
E.g.
parcels. waiting days couriers
cp00000. 15. toll
cp1234. 12. DPS
How can i do this?
Thanks a lot.
Anonymous I might not have been clear here. What I am suggesting is a measure that calculates an overall count for any parcels that are over 3 days. That Card visual can be placed on dashboard and will trigger an alert to be sent if the threshold you set is met. That card can then be linked to the actual page where you show all parcels that are over 3 days. 8k records is small. This solution proposal takes the aggregated amount, not on the parcel level. So I'm unsure of whether or not it meets your needs.
5 Replies
Anonymous What sort of alert? If "any" parcel is over 3 days? Or on a parcel level. For auto-generated alerts you would need to define a measure with your business logic and then use a card on a dashboard for automated alerts to be sent out via Power BI. ->https://docs.microsoft.com/en-us/power-bi/service-set-data-alerts
Anonymous I'm not aware of a row level way to do this. You can have a card on a dashboard that will send an email alert that you have parcels over 3 days. You would need some backend process to exclude them in further alerts if you didn't want to keep recieiving an alert after every refresh for the same items. If you would want that, then the card would work. I would suggest you create a report of a list of all the overdue parcels, and then when you recieve the alert you could click on the card and be taken to the detailed list of all parcels that are overdue.