Setting alert

[Anonymous]

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.

[Seth_C_Bauer]

@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]

@Seth_C_Bauer 

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

[Seth_C_Bauer]

@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]

@Seth_C_Bauer 

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!

[Seth_C_Bauer · Accepted solution]

@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.