Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-line-trend-176ad8e1-c494-486e-a3d4-054eba393b5e/image5_Logo300x300.png

AdvanVis - Smart Line and Trend

by AdvanVis

Free Trial
Download SampleInstructions

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
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.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
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies