For Retail & E-commerce
Power BI custom visuals for retail
Store league tables, category Paretos and the weekly trading calendar: retail views that make a Monday trading meeting short.
For Retail analysts, merchandisers, e-commerce managers. AI-generated, .pbiviz output, source code yours.
By Nawaf Sharaf · Founder & Reliability Engineer · Updated
This is the team view: everything retail teams build in Power BI, from visuals to page templates. For a single dashboard job in depth (its visuals, DAX measures and prompts), jump to the 2 retail dashboard jobs below.
Retail reporting runs on the trading week. On Monday the team looks at sales against last year and against plan by store, category and channel, then at the few products and stores that explain most of the gap. The data is usually large (transactions by store, day and product) and the questions are comparative: like-for-like growth, share of category, sell-through, conversion online. Native Power BI handles the aggregation well and its matrix, bar and line visuals cover the standard pack. What it doesn't draw natively are the views merchandisers sketch on whiteboards: a Pareto of SKUs with the 80% cut-off marked, a trading calendar where each day is coloured by sales against last year, a store league table with sparkline and rank change in one row, or a basket view of which categories sell together.
VizForge generates those as Power BI custom visuals from a description. Say which measure drives the colour, what the threshold is and how stores should be ranked, and the generator writes, type-checks and packages the .pbiviz. It binds to your existing model, so like-for-like flags, retail calendars (4-4-5 or 52/53-week) and your date table keep driving the numbers. For layout, the Design Studio's retail and e-commerce templates give you a background, a theme and a PBIP project with sample data to start from.
What retail teams need
- Like-for-like comparisons depend on a retail calendar; visuals that assume a Gregorian month misalign weeks
- SKU ranges are long: a bar chart of 3,000 products is unreadable, but a Pareto with a cut-off shows where the money is
- Trading meetings need one row per store with trend, rank change and gap to plan; that is several visuals in native Power BI
- Native visuals have no calendar heatmap for a daily trading view (as of November 2026)
- Online and store data arrive from different systems; the report must make channel differences obvious without separate pages
Featured visuals for retail dashboards
Each card links to a full reference page with example prompts, data shape, and DAX measures. Generate any of these in under 5 minutes by describing what you want — no code, no developer time.
SKU or category Pareto with the 80% cut-off.
Example: “Pareto of net sales by SKU for the selected week, bars sorted descending, cumulative % line on the right axis, vertical marker where cumulat…”
Trading calendar coloured by sales vs last year.
Example: “Calendar heatmap of daily sales vs same day last year on a retail 4-4-5 calendar, diverging colours from red (-20%) to green (+20%), weeks a…”
Category and subcategory share of sales.
Example: “Treemap of sales by category then subcategory, tile colour by margin %, labels with sales and share of total.”
Store sales vs plan with last-year marker.
Example: “Bullet chart per store: week sales bar, plan as target line, last year as a dot, sorted by variance to plan.”
Online sessions to orders conversion.
Example: “E-commerce funnel: sessions, product views, add to cart, checkout, orders, with conversion % between steps and device as a slicer.”
Channel × category mix in one view.
Example: “Marimekko with channel as column width (store, online, marketplace) and category share stacked inside each column, labels for shares above 5…”
Try one of these prompts
Click any prompt below to start a new visual. The prompt opens in your VizForge workspace pre-filled — edit it before generating, or generate as-is.
Example VizForge prompt
Trading calendar for the last 13 weeks: one cell per day coloured by sales vs same day last year (retail 4-4-5 calendar), weekends outlined, hover shows sales and transactions.
Example VizForge prompt
Store league table visual: one row per store with sales, variance to plan, a 13-week sparkline and rank change vs last week as an arrow.
Example VizForge prompt
Pareto of SKUs by margin contribution with an 80% cut-off line and the count of SKUs inside the cut-off in the title.
FAQ
Does it work with a 4-4-5 or 52/53-week retail calendar?
Yes. The visual uses the date or week columns you bind, so a retail calendar table drives it. Mention the calendar in the prompt so labels show fiscal weeks rather than calendar months.
How many SKUs can a custom visual handle?
Power BI sends a custom visual a capped number of rows (the data reduction in capabilities.json, commonly 1,000 to 30,000 rows). For long ranges, aggregate to category or top-N in a measure first and let the visual show the result.
Can I compare like-for-like stores only?
Yes, if your model has a like-for-like flag or measure. Filter or bind it as usual; the generated visual respects slicers and filters like a built-in visual.
Is there a free template for a retail dashboard?
Yes. The Design Studio has retail store and e-commerce templates you can download as a background, theme JSON and a PBIP project with sample data.
Ready to ship your retail dashboard this week?
5 free credits on signup. No card required. .pbiviz output is yours forever.
Generate your first retail visual →Building for another team? See all teams.
Retail dashboard jobs
Each page goes deep on one dashboard: the recommended custom visuals, the DAX measures behind them and ready-to-paste prompts.
Retail category managers, merchandising analysts
Best Power BI Visuals for Retail AnalyticsThe best Power BI visuals for retail analytics — store heatmaps, category Pareto, basket Sankeys, promotional…
PMs, product analysts, growth teams
Best Power BI Visuals for Product AnalyticsThe best Power BI visuals for product analytics — feature adoption funnels, retention cohorts, user flow Sankeys,…
Free retail dashboard templates
Free Design Studio page layouts for these dashboards: background image, theme JSON and PBIP project, no signup.
Retail & e-commerce template
E-commerce PerformanceHeader band, 5 icon KPIs, full-width daily trend, three-panel bottom row
Retail & e-commerce template
Retail Store PerformanceLeft story panel with stacked KPIs and slicers, map over league table and bars
Retail & e-commerce template
Retail Merchandising: Sell-ThroughBand header with logo, 5 KPIs, cumulative sell-through lines + style scatter, weekly sales columns + markdown table
SaaS template
SaaS Metrics: MRR & ChurnGlass header card, stacked KPI column, MRR movement, churn trend + cohort matrix
SaaS template
Product Analytics & Feature AdoptionPlain header, 4 bold KPIs, daily active users + activation funnel, feature-adoption bars + retention cohort matrix
Design the page around it, free
A custom visual looks best on a designed page. The free VizForge Design Studio lays out a branded report page at Power BI’s pixel size and exports the background image, a theme JSON and a PBIP project. No signup.
Open the free Design Studio →Data sources for retail reports
Where this team's data usually lives, and how to get it into Power BI: connector status, the tables to load and KPIs with DAX.
Connector in Microsoft's list
Google Analytics 4 in Power BIGoogle Analytics 4 in Power BI
No connector of its own in Microsoft's list
Shopify in Power BIShopify data in Power BI
All Power BI data source guides
Synoptic panels for retail
Floor plans and site maps with regions coloured by a measure.