Power BI Sales & Financial Performance Dashboard Template — FMCG Retail Analytics (Free PBIX Download)

Introduction: This Power BI Sales & Financial Performance dashboard tracks a chocolate brand's complete commercial operation — from headline revenue and profit KPIs down to individual sales rep performance, product-level unit rankings, and geographic distribution across 6 countries and 3 regions. Built with Current Month vs Last Month (CM vs LM) variance logic baked into every visual, it gives sales managers and commercial directors a live pulse on whether the business is accelerating or decelerating — at every level of the hierarchy simultaneously.

What's Inside This Template

Top KPI Banner (CM vs LM with variance)

All KPIs show current month value, last month baseline, and directional variance — every metric is green/positive in this view:

Four-tab navigation at top right: Revenue | Profit | COGS | Unit Sold (active) — confirming this is a multi-metric dashboard where the entire layout recontextualizes around the selected KPI dimension.

The Low Box <50 metric at -9.7% MoM is the only red KPI — tracking small-order shipments (boxes with fewer than 50 units), a common proxy for inefficient micro-orders that inflate logistics costs. Its decline is actually a positive operational signal: fewer small, costly shipments.

Unit Sold by Country (CM vs LM bar chart)

Remarkably uniform distribution — all six countries within a 38.4K unit range (326K–364.4K), each approximately 16–17% of total. Every country shows positive MoM growth between +5.9% and +8.7%. Australia has the lowest absolute volume but the highest growth rate (+8.7%), suggesting it is the fastest-accelerating market despite being smallest. India has the lowest growth rate (+5.9%) — worth monitoring as the only major emerging market in the portfolio.

Unit Sold by Region (CM vs LM)

APAC dominates at 1.0M units — comprising New Zealand, India, and Australia combined. Europe (364.3K) maps exactly to the UK figure, confirming UK is the sole European market in this dataset.

Unit Sold by Team (CM vs LM)

Four teams with Jucies and Delish nearly tied at the top (~589K each). Delish has the highest MoM growth (+8.9%) while Yummies has the lowest (+6.3%) — the gap between best and worst team growth rate is 2.6 percentage points, a manageable spread that doesn't indicate structural underperformance in any team.

Unit Sold by Product Category (CM vs LM)

Bars dominate at 1.1M units (52.6% of total), Bites at 31.3%, Other at 16.6%. Growth is positive across all three but Bars leads both volume and growth rate — the core category driving commercial performance.

Unit Sold Monthly Trend (Feb 2023 – Feb 2024)

13-month area/line chart with CM vs LM overlaid and MoM variance labeled at each data point:

Three major dips visible: Jun-23 (-13.6%), Oct-23 (-17.0%), Jan-24 (-37.5%). The Jan-24 drop of -37.5% is the sharpest single-month decline in the dataset — a post-holiday demand reset typical in confectionery. The recovery to Feb-24 (+5.7%) is modest relative to the January drop, suggesting February has not yet recovered to December levels. The Apr–May 2023 surge (+18–19%) likely reflects an Easter/spring promotional push — the largest positive spike in the entire period.

Summary of Sales Person | By Unit Sold (Table with Sparklines)

Top 5 Sales Persons panel (right sidebar) with profile photos and MoM badges confirms the top 5 generate 21.6% of total unit sold — meaning 5 reps out of the full team account for roughly one-fifth of all volume.

Karlen McCaffrey at +14.5% MoM is the standout growth performer despite ranking 5th by volume — the highest acceleration rate of any top-10 rep. Dennison Cross at +10.3% and Dotty Strutley at +10.2% are the two fastest-growing reps outside the top 4 by volume — strong candidates for expanded territory or quota increase.

Top 7 Products | By Unit Sold (right sidebar)

Top 7 products generate 40.6% of total unit sold:

Raspberry Choco (149.6K) and Fruit & Nut Bars (141.6K) are the clear volume leaders. The 50.0K unit gap between #1 (Raspberry Choco) and #7 (Orange Choco) across the top 7 shows meaningful differentiation — this is not a flat long-tail; the top 2 products each outsell #7 by 50%+.

Key Insights

1. Karlen McCaffrey is the most important rep to watch — +14.5% MoM growth while ranked 5th by volume. If this growth rate is sustained for 2–3 more months, McCaffrey will break into the top 3 by volume. This is a coaching signal: whatever McCaffrey is doing differently this month should be extracted and replicated across the team. The +14.5% MoM is nearly double the team average of +8.2%.
2. The Jan-24 -37.5% crash is structurally expected in confectionery but the Feb-24 recovery of only +5.7% is insufficient. Feb-24 at 176.9K has not recovered to December levels (173.0K → Jan → 176.9K), suggesting demand has recovered but the post-Christmas hangover is deeper than prior years. The Apr–May surge pattern from 2023 (+18–19%) should be the target benchmark for the spring recovery — if Apr-24 doesn't show a similar surge, the business is losing seasonal momentum.
3. 60.29% profit margin on a chocolate/FMCG brand is exceptionally high — consumer goods companies typically run 20–40% gross margins. This suggests either the revenue figure represents net revenue after significant COGS offset, the product mix skews heavily toward premium/high-ASP items, or the profit metric in this dataset is gross contribution rather than net profit. The COGS tab is essential to verify the cost structure before presenting these margins to external stakeholders.
4. All 6 countries within a 38.4K unit range (326K–364.4K) is statistically improbable for an organic demand distribution. Markets with different sizes, demographics, and chocolate consumption cultures should not produce near-identical unit volumes. This either reflects quota-based territory management (sales targets set by country rather than by market potential) or a dataset structured for demonstration symmetry. Analysts using this template should expect real-world data to show much higher geographic concentration.
5. Top 7 products (40.6% of volume) with Raspberry Choco and Fruit & Nut Bars each 50%+ larger than #7 confirms a healthy portfolio leader dynamic — the top 2 are genuine hero SKUs that can anchor promotional strategy, while products #5–7 (Drinking Coco, 70% Dark Bites, Orange Choco at 99–105K) are strong enough to sustain without promotion but not yet hero candidates. The 7-product toggle slider in the sidebar allows expanding or contracting the product leaderboard — a useful UX feature for different audience levels.
6. The Low Box <50 decline of -9.7% MoM (534 vs 565) is the only metric in red and the only genuinely positive operational development. Small-order boxes drive disproportionate per-unit logistics costs in chocolate distribution (temperature-controlled shipping, packaging overhead). Fewer micro-orders means better shipment consolidation and lower cost-per-unit delivered — a supply chain efficiency improvement that won't show in revenue but will show in COGS margin over time.

Who This Template Is For

1. Commercial Directors and Sales Managers at FMCG, food & beverage, or consumer goods brands who need a single-page dashboard combining KPI headline performance, geographic distribution, team ranking, product leaderboard, and individual rep tracking with MoM variance at every level
2. Sales Operations Analysts building territory and quota performance reporting that shows which reps are accelerating vs plateauing, which markets are outgrowing their peers, and which products are gaining or losing volume momentum month-over-month
3. BI Developers building sales performance systems for branded goods companies who need a production-ready template with sparkline trend columns, photo-card leaderboards, multi-tab KPI switching (Revenue/Profit/COGS/Units), and CM vs LM comparison logic throughout

How to Use

1. Download the PBIX file
2. Open in Power BI Desktop
3. Connect your sales transactions data source — the model requires a fact table with date, sales rep, country, region, team, product, product category, revenue, profit, COGS, units sold, shipment count, and box size fields
4. Use the Month, Region, Country, Team, and Product Category slicers (left panel) to filter all visuals simultaneously; switch between Revenue, Profit, COGS, and Unit Sold tabs to recontextualize the entire dashboard around each financial dimension

"The sales rep summary table in this dashboard uses a native Power BI matrix with sparklines. To add expandable team hierarchies, variance-to-target columns per rep, and conditional formatting by performance band (above/below quota) — Flexa Tables is a Microsoft-certified Power BI visual built for exactly this kind of structured sales performance tabular reporting."