Connect Power BI to your sales data

Open Power BI Desktop and choose Get Data. Connect to the source containing your sales transactions and the supporting reference tables required for analysis.

• Sales or invoice transactions
• Products and product categories
• Customers and customer groups
• Salespeople or account managers
• Regions or territories

Clean the source data in Power Query

Select Transform Data and review each query before loading it into the semantic model.

• Give columns clear business names
• Apply the correct data types
• Remove blank or invalid records
• Standardise keys
• Check duplicate transaction IDs
• Remove unnecessary columns

Create a dedicated date table

A continuous date table provides a reliable foundation for filtering and time-intelligence calculations.

DimDate =
ADDCOLUMNS(
    CALENDAR(
        DATE(2024, 1, 1),
        DATE(2027, 12, 31)
    ),
    "Year", YEAR([Date]),
    "Month Number", MONTH([Date]),
    "Month", FORMAT([Date], "MMM"),
    "Year Month", FORMAT([Date], "YYYY-MM"),
    "Quarter", "Q" & FORMAT([Date], "Q")
)

Mark the resulting table as the model's date table and create the appropriate relationship with the sales fact table.

Create the core sales measures

Measures centralise the business calculations used throughout the dashboard.

Total Sales =
SUM(FactSales[SalesAmount])

Total Cost =
SUM(FactSales[CostAmount])

Total Profit =
[Total Sales] - [Total Cost]

Profit Margin % =
DIVIDE(
    [Total Profit],
    [Total Sales]
)

Orders =
DISTINCTCOUNT(FactSales[OrderID])

Average Order Value =
DIVIDE(
    [Total Sales],
    [Orders]
)

These measures will respond automatically to filters such as year, product, region, customer and salesperson.

Add year-on-year comparison

Current values are more useful when managers can compare them with a relevant previous period.

Sales Previous Year =
CALCULATE(
    [Total Sales],
    SAMEPERIODLASTYEAR(DimDate[Date])
)

Sales YoY Change =
[Total Sales] - [Sales Previous Year]

Sales YoY % =
DIVIDE(
    [Sales YoY Change],
    [Sales Previous Year]
)

Build the first dashboard page

Design the page around the questions managers need to answer rather than around the list of available Power BI visuals.

• Place four to six headline KPIs near the top.
• Use a line chart for the sales trend.
• Use horizontal bars to rank regions or products.
• Add a matrix where detailed analysis is required.
• Keep slicers focused on useful dimensions.

Maintain consistent spacing, alignment, typography and colour usage. Visual polish should make interpretation easier rather than compete with the information.

Add useful interactivity

Use Power BI interactions to help users move naturally from the summary to the reason behind a result.

• Year and month slicers
• Region and salesperson filters
• Customer drill-through
• Report-page tooltips
• Bookmarks for alternate views

Reconcile the dashboard with the source

Before managers rely on the report, validate its important measures against the original sales or finance system.

• Check total sales for a known period
• Check order counts
• Check major customer totals
• Check product-category totals
• Check prior-year values

Keep a short validation checklist so the same tests can be repeated after significant model changes.

Publish and configure refresh

Once validation is complete, publish the report to the appropriate Power BI workspace and configure access and refresh.

• Confirm workspace ownership
• Configure source credentials
• Configure the gateway where required
• Set an appropriate refresh schedule
• Review refresh failures
• Confirm user permissions