Hi Community!
I am currently working with a Power BI Table/Matrix that displays weekly budgets across various areas.
| Department |
2024-01 |
2024-02 |
2024-03 |
| Group A |
5 |
5 |
5 |
| Group B |
5 |
5 |
blank |
I am interested in setting up a mechanism to automatically notify the respective team leaders via email when there is a blank value for the current week's budget in the associated Excel file.
Given that my Power BI dataset is derived from multiple tables, I would like to inquire whether it is feasible to create a trigger based on a blank value within a table visual and subsequently send individualized emails to different recipients.
Any insights or suggestions on how to achieve this would be greatly appreciated.
Thank you!