Building your first Power BI dashboard can feel overwhelming. This guide walks you through the complete process: connecting data, modeling tables, writing measures, designing visuals, and publishing to the web. By the end, you will have a working sales dashboard you can customize for your own data.
What you will build
We are building a Sales Performance Dashboard with four components: a KPI header row (revenue, orders, average order value), a trend chart showing monthly revenue, a regional breakdown bar chart, and a product category table with conditional formatting. This covers the essential patterns you will reuse in every dashboard you build.
Step 1: Prepare your data in Excel
Start with two tables in an Excel workbook. Table one is Sales with columns: OrderID, Date, CustomerID, ProductID, Region, Quantity, UnitPrice. Table two is Products with columns: ProductID, ProductName, Category. Having two tables forces you to learn data modeling, which is the foundation of every Power BI project. If you try to work with a single flat table, you will hit limitations quickly.
Step 2: Load data into Power BI
Open Power BI Desktop and click Get Data, then Excel Workbook. Select both tables and click Load. Go to the Model view to see the relationship. Power BI may auto-detect the relationship between Sales[ProductID] and Products[ProductID]. If it does not, drag one column to the other to create a one-to-many relationship.
Step 3: Create a proper date table
Every Power BI model needs a dedicated date table for time intelligence to work. Go to Modeling, then New Table, and enter: Dates = CALENDAR(DATE(2024,1,1), DATE(2026,12,31)). Then add columns: Year = YEAR(Dates[Date]), Month = FORMAT(Dates[Date], "MMMM"), MonthNum = MONTH(Dates[Date]). Create a relationship between Dates[Date] and Sales[Date]. Mark this table as a date table in the properties.
Step 4: Write your DAX measures
Create three measures. Total Revenue = SUMX(Sales, Sales[Quantity] * Sales[UnitPrice]). Total Orders = DISTINCTCOUNT(Sales[OrderID]). Avg Order Value = DIVIDE([Total Revenue], [Total Orders], 0). Put these measures in a dedicated Measures table (right-click in the Fields pane and create a new table named _Measures, then move your measures there). This keeps your model organized.
Step 5: Build the KPI header
Switch to Report view. Add three Card visuals across the top of the page. Drag Total Revenue to the first card, Total Orders to the second, and Avg Order Value to the third. Format each card: increase the font size, add a category label, and set the background to transparent. Align all three cards in a row using the alignment tools.
Step 6: Add the trend chart
Add a Line Chart below the KPI cards. Drag Dates[Date] to the X-axis (it will automatically group by hierarchy) and [Total Revenue] to the Y-axis. Remove the date hierarchy so it shows continuous months instead of drilling. Add [Total Orders] as a secondary Y-axis to show volume alongside revenue. This dual-axis chart is one of the most common executive dashboard patterns.
Step 7: Add the regional breakdown
Add a Clustered Bar Chart. Drag Sales[Region] to the Y-axis and [Total Revenue] to the X-axis. Sort by revenue descending. Add conditional formatting: right-click the data bars and add a color rule that goes from light gold for low values to dark gold for high values. This makes the top regions visually pop.
Step 8: Add the product table with formatting
Add a Table visual. Drag Products[Category], [Total Revenue], [Total Orders], and [Avg Order Value] to it. Apply conditional formatting to the revenue column with data bars. Add a slicer for Dates[Year] so users can isolate data by year. Test the interactivity by clicking a bar in the regional chart and watching the table filter automatically.
Step 9: Add finishing touches
Add a text box with the dashboard title. Add a slicer for Region to give users another filter dimension. Group your KPI cards and align them to a grid. Set the page background to a dark theme that matches your brand. Add a subtle border around each visual section. These small design choices separate professional dashboards from amateur ones.
Step 10: Publish and share
Click Publish and select your workspace. In the Power BI Service, pin your visuals to a new dashboard. Set up a scheduled refresh if your Excel file is in OneDrive or SharePoint. Share the dashboard with your team by adding them to the workspace. They can view and interact with the report without needing Power BI Desktop.
Next steps
This dashboard covers the basics, but real-world projects need row-level security, drill-through pages, and advanced DAX. Our [Power BI training](/courses/power-bi/) course builds on exactly this foundation with enterprise-grade scenarios and live instructor guidance.