https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image5_Logo300x300.png
AdvanVis - Smart Line and Trend
Line charts with last year, targets, a variance strip, a projection and plain-English insights.
AdvanVis - Smart Line and Trend labels the points that matter and explains the trend in plain English: last year as a dashed line, the budget with the gap shaded, the difference for every period, a projection with its likely range, and findings you can trust.
FREE FEATURES (no licence needed, no watermark)
• Line, smooth, stepped, area and stacked area; up to six measures or a Legend
• Small multiples (a chart per series) and a second Y axis
• Smart labels: first, last, highest and lowest points, with series names at the line ends
• Show values as running total, year to date or an index (first period = 100)
• Comments from your data: a text field becomes numbered notes on the line and a list under the chart
• Trend line and moving average, peaks and troughs, average, median and fixed lines, a reference band and a shaded period (Analytics pane)
• Zoom slider for long series, and fetch more data up to 30,000 periods
• Conditional formatting (fx) for point colours, colour-blind safe schemes
• Cross-highlighting, cross-filtering, drill-down, tooltips, Show condition
• Basic headline, keyboard navigation, screen reader text and high contrast support
PRO FEATURES (additional purchase may be required; one-month free trial through Microsoft AppSource)
• Compare to last period: a dashed line and the change on the last label
• Target or budget: a target line with the gap shaded, scored met or missed
• Variance strip: the difference and difference % for every period, in the IBCS style
• Projection: the trend and seasonal pattern carried forward, with a 95% or 80% likely range
• Smart insights: a headline and findings on trend, runs, unusual periods, largest fall, periods below zero, targets and series
• How calculated: hover or Tab to any finding to see the numbers behind it
• Design tips while editing
In Power BI Desktop every feature can be used while you build your report. When the report is shared in the Power BI service, viewers need the Pro plan to see the Pro features; everyone else sees the free chart.
HOW THE INSIGHTS AND THE PROJECTION WORK
Both are worked out inside the visual by built-in statistical rules (least-squares trend, seasonal averages, robust outlier scores) and written in plain English from templates. The projection carries the past pattern forward and is always shown as a range; it is not a guarantee. No generative AI is used.
PRIVACY
Everything is calculated inside the visual from the data in your report. No data leaves the report and the visual makes no network calls.
GET STARTED
Add the visual, then drag a date or period into X axis and a measure into Values. Add Compare to and Target or budget for the dashed line, the shaded gap and the variance strip. Download the sample report for a guided tour of every feature.
Support: https://advanvis.co.uk/support
Visual capabilities
This visual is certified by Power BI
At a glance
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image2_01smartinsightsandvariancestrip.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image2_01smartinsightsandvariancestrip.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image4_02projectionandyeartodate.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image1_03commentsandindex.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image0_04smallmultiplesandsecondaxis.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image3_05trendpeaksbandsstacks.png