Set alerts on table visualization

Hi! robbert-bi 

You have to look out of Power BI for this. You can use Python scripts or Power Automate (PA).

For PA you can use dax like:

AlertFlag = IF([Excess Percentage] > 0, 1, 0)

then you can create a table viz and necessary use other necessary cols, use it in PA viz and create a flow to send out emails.

Solution:

1. Add an Alert Flag: Create a calculated column in Power BI: AlertFlag = IF([ExcessPercentage] > 0, 1, 0)

2. Power Automate Integration: In Power BI Service, trigger a Power Automate flow for flagged rows. Use "When a data-driven alert is triggered" in Power Automate to send emails to project managers and stakeholders.
   
   

3. Test & Activate: Test the flow and activate it for real-time alerts.