How to Create a Financial Dashboard in Power BI

A well-built financial dashboard transforms raw data into strategic decisions. In this guide, we'll create a Power BI panel step by step with P&L, cash flow and profitability indicators — from zero to published.

Step 1: Prepare Your Data

Dashboard quality depends on data quality. Common sources:

• ERP: SAP, Dynamics, NetSuite — export financial transactions
• Spreadsheets: Excel with revenue and expense history
• Database: Direct connection via SQL Server, MySQL or PostgreSQL
• Accounting: Trial balance and P&L from your accountant

Step 2: Data Modeling in Power BI

1. Import data sources (Get Data)
2. Remove duplicates and blank rows
3. Standardize data types (dates, numeric values)
4. Create a calendar table (dCalendar) for time analysis
5. Establish relationships between tables in Model View

Step 3: Essential DAX Measures

• Total Revenue: CALCULATE(SUM(Financial[Value]), Financial[Type] = "Revenue")
• Total Expenses: CALCULATE(SUM(Financial[Value]), Financial[Type] = "Expense")
• Net Profit: [Total Revenue] - [Total Expenses]
• Margin: DIVIDE([Net Profit], [Total Revenue], 0)
• YTD Revenue: TOTALYTD([Total Revenue], dCalendar[Date])

Step 4: Build Visualizations

Page 1 — Overview

• Cards: Revenue, Expenses, Profit, Margin
• Line chart: Revenue vs Expenses monthly (12 months)
• Bar chart: Top 5 expense categories
• KPI: Monthly revenue vs target

Page 2 — P&L Statement

• Matrix table with hierarchy: Group > Category > Subcategory
• Columns: Current Month, YTD, % of Revenue
• Conditional formatting to highlight variances

Page 3 — Cash Flow

• Waterfall chart: monthly inflows and outflows
• Area chart: projected balance for next 3 months
• Table: accounts payable and receivable by due date

Step 5: Design & UX

• Use max 3-4 colors (green for positive, red for negative)
• Align all elements to a grid
• Clear titles on each visual
• Date and cost center filters at the top
• Avoid 3D charts — always use 2D

Step 6: Publish & Share

1. Publish to Power BI Service
2. Configure scheduled data refresh
3. Create an App Workspace for the finance team
4. Configure Row-Level Security if needed
5. Share via link or embed in Teams/SharePoint