Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DataSci_Barry
Regular Visitor

Alerts in line charts

Hi! I'm pretty new to using Power BI.

 

I've created a report with several measures and charts. In one of the charts, I plotted the cumulative sum of sales (y-axis) by the month of the year (x-axis). The legend of the plot is the year, so the plot shows the cumulative sum for each year. This allows me to compare the total sales of the current year with the cumulative sum of the previous years for each month.

 

Now, I want to create an alert to send a message if a certain value (target) is reached for each month, so I can track sales easily. Can I do this with the chart I mentioned, or should I create a new chart only with the cumulative sales of the current year and set the alert there?

 

My main question in this forum is how to set up the alert in Power BI. I believe I need to use Power Apps to send a message to a set of email addresses.

 

I hope I explained this clearly. Thanks!

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @DataSci_Barry 
Alerts in Power BI work only for KPI, card, or gauge visuals.
More information about alerts and guides for creating is in the linked documentation and video :
https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

https://www.youtube.com/watch?v=B1JSEh30J1c

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @DataSci_Barry 
Alerts in Power BI work only for KPI, card, or gauge visuals.
More information about alerts and guides for creating is in the linked documentation and video :
https://learn.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

https://www.youtube.com/watch?v=B1JSEh30J1c

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.