https://catalogartifact.azureedge.net/publicartifacts/advanvis.advanvis-smart-bar-column-7732da89-cff1-4d29-bd97-38f7b5b5281d/image4_Logo300x300.png
AdvanVis - Smart Bar and Column
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
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