14. Visuals and Their Formatting
14.23 The Analytics Pane
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.
Thodkyaat sangaycha tar (quick recap)
Aadhi prashna, mag chart; theme vapra; titles meaningful theva; aani pratyek visual ne ekach prashnache uttar dyava. Aata pudhe jaauya Maharashtra cha map banvayla!