Forum Discussion
Setting alert
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.
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
For example ,
the dataset is look like this:
parcel. waiting days couriers
cp12345 15 toll
cp01122. 2 ups
Then there should be an alert as the first parcel has been waiting for over 3 days.
So i should say it is on a parcel level.
Thanks a lot
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.
Anonymous
Is it working for a large amount of data becuz i have around 8000 lines.
Also i want to ask is it possible to get the relevant project names (which row triggered the alert)?
Thanks a lot!