(+351) 21 24 10006  ·  info@bconcepts.pt
Carnaxide, Lisbon

How to create a threshold alert in Power BI: step by step

João Barros 16 de November de 2026 4 min read

This tutorial shows how to create a threshold alert in Power BI using a DAX measure and a card visual, useful for monitoring KPIs and receiving notifications when a value exceeds a threshold. It explains why and the practical steps to implement an alert in the Power BI service.

Prerequisites

  • Power BI Desktop installed.
  • Account in the Power BI service (Power BI Service) to publish reports.
  • Simple data with a numeric metric (for example, Sales) and a time dimension.

Step 1: Prepare the data and create the main measure

Open Power BI Desktop and load your data (Excel, CSV or another source). Create a measure that calculates the metric you want to monitor. Here we use the Total Sales example.

Vendas Totais = SUM('Vendas'[Valor])

Step 2: Create a comparison measure with the threshold

Create a measure that compares the metric with a fixed or dynamic threshold. A fixed threshold is useful to start. The measure returns a boolean or text value that makes visualization and alerting easier.

Limite Vendas = 100000
Vendas Acima do Limite =
IF([Vendas Totais] > [Limite Vendas], 1, 0)

Step 3: Show the status in a card and format

Drag the 'Vendas Totais' measure onto a card visual. Also add the 'Vendas Acima do Limite' measure as a separate card or use a card with a measure that returns text to make reading easier.

Estado Vendas =
IF([Vendas Acima do Limite] = 1, "Acima do Limiar", "Dentro do Limiar")

Format the card: use conditional colors (if available in your visual) or create two cards (one green, one red) and control visibility with Bookmarks if you want distinct presentations.

Step 4: Publish to the Power BI service

When the report is ready, publish it to your workspace in the Power BI service: Home > Publish. The alert can only be created in the Power BI Service on a card that shows a numeric value.

Step 5: Create the alert in the Power BI Service

In the Power BI Service, open the dashboard or pin the report card to a dashboard. Select the card (that shows Total Sales) and click the three dots (...) > Manage alerts (Gerir alertas) or Alerts depending on the language. Create a new alert defining:

  • Condition: above or below a value.
  • Threshold value (you should use the same logical value, e.g. 100000).
  • Notification frequency (for example, when it changes).
  • Send an alert email (optional) or use Power Automate for advanced actions.

Step 6: (Optional) Integrate with Power Automate for advanced alerts

For customized notifications (Teams, contextual email, logs) use Power Automate. Create a flow with the trigger 'When a data driven alert is triggered' from the Power BI connector. In the flow, add actions such as sending a message to Teams or creating a record in a database.

Trigger: Power BI - When a data driven alert is triggered
Action: Microsoft Teams - Post a message
Action: Office 365 Outlook - Send an email

Verify the result

Confirm that the card on the dashboard updates and that the alert triggers when the data exceed the threshold. To test, modify the source data (or apply a period filter) to force Vendas Totais > 100000 and observe whether the Power BI service sends the notification or the Power Automate flow runs.

Conclusion

You now have a threshold alert in Power BI that notifies you when a metric exceeds a defined value. Next steps: make the threshold dynamic using parameters or a thresholds table, and create richer Power Automate flows. Tip: always test the alert with sample data before relying on the production environment — which metric do you want to monitor next?