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 · 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.

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.

Try this prompt → starts free

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.

Try this prompt → starts free

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.

Try this prompt → starts free

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.

Free retail dashboard templates

Free Design Studio page layouts for these dashboards: background image, theme JSON and PBIP project, no signup.

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.

All Power BI data source guides

Synoptic panels for retail

Floor plans and site maps with regions coloured by a measure.

Make the report.
Then make it yours.

The Design Studio, templates and tools are free with no account (exports carry a small VizForge mark until you sign in). Sign up when you want AI: 5 credits on us, no card.

Generated visuals are type-checked and built before you download them; one that fails the quality SLA refunds its credits. See all features or pricing.