The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
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
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
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |