Finance Dashboard End-to-End: Star, DAX, Layout | Excel & Power BI S2 Ep6 Finale

📂 Download the AtlasParts dataset and the Episode 12 Power BI starter file: https://github.com/GoCelesteAI/excel-powerbi-for-finance The Season 2 finale of *Excel & Power BI for Finance*. Eleven episodes of preparation collapse into one page. We take everything we've built — the AtlasParts star schema (Episode 9), the DAX measures from Episodes 10 and 11 — and assemble the dashboard finance executives actually look at on Monday morning. This episode is about *layout, polish, and interaction*. The DAX is already done. The model is already done. What's left is the part most tutorials skip: making it readable, making it survive a slicer click, and making it feel like a real product instead of a developer's scratch pad. What You'll Build: - KPI row — four cards across the top with YoY deltas in the right colour (Revenue YTD, Gross Margin %, OPEX, EBITDA). - Revenue trend — the canonical YTD vs Prior-Year YTD two-line chart, with the calendar's month on the x-axis. - Margin by region — horizontal bar chart of Gross Margin % broken out by region. - AR aging — column chart with the standard 0–30 / 31–60 / 61–90 / 90+ buckets, driven by a calculated column on the AR fact. - Budget vs Actual — variance table with conditional formatting on the variance column. - Cross-filter wiring — click any column in the revenue chart, watch every other visual respond. The signature Power BI moment. - Region slicer — single-select scrub demonstrating filter context propagating through the model. Timestamps: 0:00 - Intro — The capstone 0:50 - Preview — what we'll ship 1:40 - KPI row — the top strip 3:00 - Revenue trend — YTD vs PY 4:30 - Margin by region — the bar-vs-column choice 6:00 - AR aging — calculated column vs measure 7:30 - Budget vs Actual — when a table is the right answer 9:00 - Cross-filter — one click, every visual responds 10:30 - The final dashboard — the reveal 12:00 - Recap — twelve episodes, one report 13:10 - End screen — Season 2 wrap Key Takeaways: 1. A finance dashboard answers five questions at a glance: how are we tracking versus plan, this year versus last, the monthly trend, which regions are dragging, where the cash sits. Anything else belongs on a drill-through page or a different report. Discipline about what doesn't go on the page is most of the work. 2. The four-zone layout is the production default — KPI row across the top, trend chart below it, breakdown chart on one side, AR aging or budget-vs-actual along the bottom. It's not a Power BI convention; it's a CFO convention. KPI cards earn their keep through the deltas, not the bare numbers. 3. Bar versus column matters. Long category labels go in horizontal bars (region names won't fit under vertical columns). Short calendar labels go in vertical columns. The mistake of putting region names under a column chart with rotated labels is one of the most common dashboard tells. 4. AR aging buckets live as a calculated column on the AR fact, computed via SWITCH on days outstanding. The dollars on the y-axis stay a measure. This is the canonical column-for-grouping, measure-for-aggregation split that finance models almost always need. 5. Cross-filter is the signature Power BI moment. Click any visual, watch every other visual respond. No DAX, no event handlers — the relationships in the star schema do all the work. This is what makes a Power BI dashboard a Power BI dashboard rather than a static spreadsheet print. #PowerBI #DAX #FinanceDashboard #Capstone #FinanceAnalytics #PowerBIDesktop #ExcelToPowerBI #FinancialReporting #BusinessIntelligence #Season2Finale --- Generated by GoCelesteAI · part of the Excel & Power BI for Finance series