Anomaly detection (preview)

APPLIES TO: Does not apply to.Power BI service for consumers Applies to.Power BI service for designers & developers Applies to.Power BI Desktop Does not apply to.Requires Pro or Premium license

Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis. With just a couple of clicks, you can easily find insights without slicing and dicing the data. You can create and view anomalies in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.

This feature is in preview, so you first need to turn on the feature switch. Go to File > Options and Settings > Options > Preview features, and make sureĀ Anomaly detection is turned on:

Screenshot showing how to enable Anomaly detection preview feature switch.

Get started

This tutorial uses online sales data for various products.To follow along with this tutorial, download the sample file of an online-sales scenario.

You can enable Anomaly detection by selecting the chart and adding "Find Anomalies" option in the analytics pane.

Screenshot showing entry point for anomaly detection

For example, this chart shows Revenue over time. Adding anomaly detection automatically enriches the chart with anomalies, and the expected range of values. When a value goes outside this expected boundary, it's marked as an anomaly. Check out this technical blog for more details about the Anomaly Detector algorithm.

Screenshot showing how to add anomalies

Format anomalies

This experience is highly customizable. You can format the anomaly's shape, size, and color, and also the color, style, and transparency of expected range. You can also configure the parameter of the algorithm. If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly.

Screenshot showing how to format anomalies

Explanations

Besides detecting anomalies, you can also automatically explain the anomalies the data. When you select the anomaly, Power BI runs an analysis across fields in your data model to figure out possible explanations. It gives you a natural language explanation of the anomaly, and factors associated with that anomaly, sorted by its explanatory strength. Here I see that on August 30, Revenue was $5187, which is above the expected range of $2447 to $3423. I can open the cards in this pane to see more details of the explanation.

Screenshot showing how to to view explanations

Configure explanations

You can also control the fields that are used for analysis. For example, by dragging Seller and City into the Explain by field well, Power BI restricts the analysis to just those fields. In this case, the anomaly on August 31 seems to be associated with a particular seller and particular cities. Here, seller "Fabrikam" has a strength of 99%. Power BI calculates strength as the ratio of the deviation from expected value, when filtered by the dimension to the deviation in total value. For example, it's the ratio of actual minus expected value, between the component time series Fabrikam and the aggregate time series overall Revenue for the anomaly point. Opening this card shows the visual with a spike in the revenue for this seller on August 31. Use the Add to report option to add this visual to the page. Screenshot showing how to configure explanations

Limitations

  • Anomaly detection is only supported for line chart visuals containing time series data in the Axis field.
  • Anomaly detection isn't supported with legends, multiple values or secondary values in line chart visual.
  • Anomaly detection requires at least 12 data points.
  • Forecast/Min/Max/Average/ Median/Percentile lines doesn't work with Anomaly detection.
  • Direct Query over SAP data source, Power BI Report Server, Live Connection to Azure Analysis Services and SQL Server Analysis Services aren't supported.
  • Anomaly Explanations doesn't work with 'Show Value As' options.
  • Drilling down to go to the next level in the hierarchy isn't supported.