14. Visuals and Their Formatting
14.23 The Analytics Pane
Start with a problem
Ravindra wants a reference line on the City chart so managers can see who is above the average city, and a short forecast on the daily Nagpur orders.
Explain simply
The Analytics pane (magnifier icon) adds reference lines – constant, average, median, min, max, percentile, trend – and, on line charts with a continuous date axis, a forecast.
Show the data
| City | Total Sales (₹) |
|---|---|
| Pune | 850 |
| Nashik | 800 |
| Kolhapur | 450 |
| Total | 2,100 |
About this data: This table uses columns: City, Total Sales (₹). This table uses columns: Line, Value. This table uses columns: Line, Available on (typical), Example. This table uses columns: Wrong result, Reason, Correction. Values shown are the lesson examples already on this page (not a new dataset).
Fictional sample data. Practice file: visuals_orders_apr_may_2026.csv (source: src/practice/).
Demonstrate
- Select the Total Sales by City bar chart › Analytics pane.
- Average line › + Add. Data label On.
- Constant line › + Add › value 800 › label City target.
- On the daily line chart (continuous date axis): Forecast › + Add › length 7 points, confidence 95%.
Show the result
Your result should look like this (fictional sample):
| Line | Value |
|---|---|
| Average line | ₹700 (2,100 ÷ 3 cities) |
| Constant line | ₹800 |
| Above average | Pune 850, Nashik 800 |
| Below average | Kolhapur 450 |
Explain what happened
The average line averages the measure across the bars currently shown – the three cities – not across the eight orders (which would be 262.50).
Explore further
- Forecast is a statistical extension of the pattern – not a business plan.
- Exclude an incomplete last day before forecasting.
Detailed reference for this lesson:
Select a supported visual › Visualizations › Analytics (magnifying-glass icon). Available lines depend on the visual type:
| Line | Available on (typical) | Example |
|---|---|---|
| Constant line (X or Y) | Bar, column, line, scatter | Y = 10 minutes delivery target on an Avg Delivery Time chart |
| Min / Max line | Column, line, scatter | Highlight best/worst month |
| Average line | Column, line, scatter | Average daily orders |
| Median line | Column, line, scatter | Median basket value |
| Percentile line | Column, line, scatter | 90th percentile of delivery time |
| Trend line | Line, column (continuous axis), scatter | Long-term trend of orders |
| Forecast | Line chart with a continuous date axis and a single measure | Next 30 days of orders, with a confidence interval |
| Error bars | Line, bar/column, scatter (newer versions) | Min–max range |
| Symmetry shading / Ratio line | Scatter | Compare two measures |
Steps in Power BI – forecast daily orders
- Create a Line chart with X-axis =
'Date'[Date](Type Continuous) and Y-axis = Total Orders. No legend and no secondary axis. - Analytics › Forecast › + Add line.
- Units Points, Forecast length 30, Confidence interval 95%, Seasonality (Auto or 7 for weekly patterns). Use Ignore the last 1 point if the latest day is incomplete.
- Format the forecast line colour and confidence band style › Apply.
Ravindra Bagale's Tip
Friends, remember: forecast options go missing when the X-axis is categorical or when there is a legend or a second measure. Use a continuous date axis with a single measure. Also, a forecast doesn't know about next year's Diwali date, so treat it as a rough baseline, not a promise. Try it once more, then move on.
Ravindra Bagale's Tip – मराठी
मित्रांनो, लक्षात ठेवा: X-axis categorical असेल किंवा legend किंवा दुसरा measure असेल तर forecast चे options गायब होतात. एकाच measure सोबत continuous date axis वापरा. आणि forecast ला पुढच्या वर्षीच्या दिवाळीची तारीख माहीत नसते, म्हणून त्याला अंदाजे baseline समजा, वचन नाही. पुन्हा एकदा करून बघा, मग पुढे जा.
Ravindra Bagale's Tip – हिंदी
दोस्तों, याद रखो: X-axis categorical हो या legend या दूसरा measure हो तो forecast के options ग़ायब हो जाते हैं. एक ही measure के साथ continuous date axis इस्तेमाल करो. और forecast को अगले साल की दिवाली की तारीख़ नहीं पता होती, इसलिए उसे मोटा-मोटा baseline समझो, वादा नहीं. एक बार फिर करके देखो, फिर आगे बढ़ो.
Practice task
On a column chart of Avg Delivery Time by City, add a constant line at 10 minutes (label "Target") and an average line. Then add a forecast to a daily orders line chart.
Fix common mistakes
| Wrong result | Reason | Correction |
|---|---|---|
| Forecast option missing | Categorical axis, legend, or several measures | Continuous date axis, one measure, no legend |
| Average line shows 262.50 | Expected the average order | The line averages bars; build an AVERAGE measure for per-order average |
| Constant line hard-coded forever | Target changes monthly | Use an fx value from a target measure |
Practise independently
Practice task
Filter the chart to Blinkit only. What does the average line show?
Hints
- Blinkit by city: Pune 650, Nashik 450, Kolhapur 0.
Solution
(650 + 450 + 0) ÷ 3 = ₹366.67.
Think like a professional
Reference lines turn a chart into a judgement. A professional names the line (target, average) and knows exactly what it averages.
Revision card