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-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image4_Logo300x300.png

AdvanVis - Smart Bar and Column

by AdvanVis

Free Trial
(1 ratings)
Download SampleInstructions

Bar and column charts with last year, targets, an IBCS variance chart and plain-English insights.

dvanVis - Smart Bar and Column draws bars and columns the way finance teams read them: last year behind each bar, the target on every bar, the difference in amount and per cent, and smart insights that explain what happened in plain English. FREE FEATURES (no licence needed, no watermark) • Bars, columns, stacked, clustered and 100% stacked, lollipop and dumbbell styles • Automatic direction (IBCS): periods as columns in time order, categories as bars, largest first • Axis break when one bar dwarfs the rest, so the others stay readable • Pareto line with its 0-100% scale and the point where 80% is reached • Top N with a working Other bar: hover Other to see what it contains • Average, median and fixed reference lines, and a Total bar • Highest and lowest highlighting, colour rules and fx conditional formatting • Images or flags per category from a column of images stored in your data • Values below zero drawn as bars in their own colour • Show condition: hide the chart when a 0/1 measure is 0 • Basic headline, tooltips, drill-down, cross-filtering, scrolling, keyboard navigation and high contrast support PRO FEATURES (additional purchase may be required; one-month free trial through Microsoft AppSource) • Compare to last period: a grey bar behind each bar and the change in the labels • Target or budget: a marker or bullet band on every bar, met or missed • Variance chart: the difference and difference % to target or last period, beside bars or above columns • Smart insights: a headline and findings on change drivers, targets, losses, series mix, concentration, outliers and growth • 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 WORK Smart insights are worked out inside the visual by built-in statistical rules (ranking, shares, growth, targets, losses and outliers) and written in plain English from templates. 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 category into Category and a measure into Values. Add Compare to and Target or budget for the variance chart and target insights. 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-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image1_01smartinsightsandvariance.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image1_01smartinsightsandvariance.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image5_02timeascolumnswithvariance.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image0_03lossesandseries.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image2_04axisbreakparetotopn.png
https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image3_05stylesimagesandlines.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