How to Build a Sales & Margin Dashboard in Power BI

Revenue on its own hides the story. A growing top line can sit on top of shrinking margins, heavy discounting, or an unprofitable product mix. A good sales and margin dashboard puts those side by side on one page so a manager can see not just how much was sold, but how good that revenue was. Here is the practical shape of that build.

Start with a clean star-schema model

Reliable dashboards start with a tidy model, not clever visuals. Aim for a single fact table of sales transactions surrounded by simple dimension tables, and always include a dedicated date table so time calculations behave.

• FactSales: one row per order line with sales, profit, quantity, and the keys.
• DimProduct, DimCustomer, DimGeography: the attributes you filter and group by.
• DimDate: a marked date table that powers month trends and year-on-year comparisons.
• Connect each dimension to the fact table with single-direction one-to-many relationships.

The DAX measures that matter

Keep measures in one dedicated table so they are easy to find, and build from base measures upward. The core set for sales and margin is small:

• Revenue = SUM of sales, and Profit = SUM of profit.
• COGS = Revenue − Profit when there is no explicit cost column.
• Gross Margin % = DIVIDE(Profit, Revenue) — the metric the whole page hangs on.
• Revenue YoY % using SAMEPERIODLASTYEAR to show whether growth is real.
• A margin target and a status measure so “under pressure” is visible at a glance.

Design one focused page

Resist the urge to show everything. A single, well-ordered page beats five crowded ones.

• A top row of KPI cards: revenue, gross margin, profit, COGS, and year-on-year growth.
• A trend chart of revenue against the prior period, with margin on its own line versus a target.
• A product matrix showing revenue, COGS, profit, and margin with colour cues for loss-makers.
• Slicers for region, category, segment, and date so the same page answers many questions.

Validate before you share

Finally, sanity-check the numbers: totals should match the source, COGS plus profit should equal revenue on every visual, and year-on-year figures should tie out to a manual check. A dashboard is only useful if people trust it — and trust is built by validation, not visuals. This is exactly the build behind the Sales & Margin Performance Dashboard in the portfolio.