AI Visuals & Pattern Discovery
Use Power BI's AI visuals — Key Influencers, Decomposition Tree, Q&A, Smart Narrative — plus the Analyze feature, grouping, binning, clustering, forecasting, and anomaly detection.
Let Power BI find the insights
Think of a detective with a magnifying glass. You could spend hours scanning every row of data looking for patterns — or you could let Power BI’s AI do the scanning for you.
Power BI has built-in AI visuals that automatically find what’s driving your metrics, decompose numbers into contributing factors, forecast future trends, and flag data points that look unusual. These features are heavily tested on the PL-300 exam.
AI visuals
Key Influencers
What it does: Identifies which factors most influence a metric — what makes it increase, decrease, or fall into a category.
Riley at Coastal Fresh (🛒) uses Key Influencers to find what drives high-value orders:
- Region: North is 2.3x more likely to produce orders over $200
- Day of week: Saturday orders are 1.8x more likely to be high-value
- Product category: Organic products increase order value by $35 on average
How to use: Insert the Key Influencers visual → drag the metric to “Analyze” → drag potential factors to “Explain by”
Decomposition Tree
What it does: Breaks down a measure into contributing dimensions, letting you drill into what makes up the total.
Nadia at Prism Agency (📊) decomposes total campaign spend → by Platform → by Client → by Campaign Type. The tree shows that 60% of spend is on Meta Ads, and within Meta, Client X accounts for 40%.
How to use: Insert Decomposition Tree → drag a measure to “Analyze” → drag dimensions to “Explain by” → click each level to drill
Q&A Visual
What it does: Lets users type natural language questions and get instant visual answers.
“What was total revenue last month by region?” → Power BI generates a bar chart.
Smart Narrative
What it does: Automatically generates a text summary of the data, highlighting key trends and outliers. (Related to the Copilot narrative visual covered earlier — Smart Narrative is the non-Copilot version.)
| AI Visual | Best For | Example |
|---|---|---|
| Key Influencers | Finding what drives a metric up or down | What makes customers churn? What increases order value? |
| Decomposition Tree | Breaking down a total into component parts | Where is our $5M revenue coming from? Which segments contribute most? |
| Q&A | Ad-hoc questions in natural language | Users type 'show sales by region last quarter' and get a chart |
| Smart Narrative | Auto-generated text summaries | Executive reports that need plain-English explanations |
The Analyze feature
Right-click any data point → Analyze to access quick AI explanations:
- Explain the increase/decrease — why did revenue jump in March?
- Find where this distribution is different — which segments deviate from the overall pattern?
Power BI runs analysis in the background and shows contributing factors ranked by impact.
Grouping, binning, and clustering
Grouping
Manually combine category values into custom groups.
Dr. Ethan at Bayview Medical (🏥) groups individual departments into “Surgical”, “Medical”, and “Support” groups for higher-level reporting.
How to: Right-click values in a visual → Group → select items to combine
Binning
Automatically group numeric values into ranges (bins).
Kenji at Apex Manufacturing (🏭) bins order quantities into ranges: 1-10, 11-50, 51-100, 100+ to see the distribution of order sizes.
How to: Right-click a numeric field in the Fields pane → New group → set bin size
Clustering
Automatically identifies natural groupings in scatter plot data using machine learning.
How to: On a scatter plot → select the ”…” menu → Automatically find clusters
Power BI creates cluster labels (Cluster 1, Cluster 2, etc.) that you can rename to business-meaningful names.
Reference lines, error bars, and forecasting
Analytics pane additions
Select a line chart or bar chart → Analytics pane (magnifying glass icon):
| Feature | What It Shows |
|---|---|
| Constant line | A fixed reference value (e.g., target = $100K) |
| Average line | The average of the data series |
| Min/Max line | The minimum or maximum value |
| Trend line | Linear or polynomial trend overlay |
| Forecast | Predicted future values based on historical data |
| Error bars | Confidence intervals around data points |
Forecasting
Forecast extends a line chart into the future based on historical patterns.
How to configure:
- Forecast length: How far ahead (e.g., 3 months)
- Confidence interval: Width of the prediction band (e.g., 95%)
- Seasonality: Auto-detect or manual (e.g., 12 for monthly seasonality)
Anomaly detection
Anomaly detection automatically identifies data points that deviate significantly from expected patterns.
On a line chart:
- Analytics pane → Find anomalies
- Power BI highlights unusual data points with markers
- Click an anomaly → Power BI explains possible causes
Riley at Coastal Fresh (🛒) spots an anomaly in her daily sales: a sudden spike on March 15. Clicking the anomaly reveals it coincided with a marketing promotion in the North region.
Exam tip: anomaly detection requirements
Anomaly detection works on line charts with a date axis. It requires enough historical data to establish a pattern (typically 12+ data points). It uses machine learning to calculate expected values and flags points that fall outside the confidence interval.
Knowledge check
Riley wants to understand what makes some orders high-value (over $200). Which AI visual should she use?
Kenji adds a forecast to his production line chart. The forecast shows a downward trend with a wide confidence interval. What does the wide interval suggest?
🎬 Video coming soon
Next up: Workspaces and Distribution — publish, share, and distribute your reports.