Power BI for Beginners: Build a Sales Dashboard for a Small Shop

Imagine you run a small mobile accessories shop. Every month, your sales are stored in Excel, but answering simple questions means scrolling through rows.

Which product sells the most? Which city generates the most revenue? Is sales performance improving?

Power BI can turn that Excel data into an interactive dashboard where these answers are visible at a glance.

In this beginner-friendly tutorial, we'll build a simple sales dashboard step by step.

[Featured Image]

Alt text: Power BI sales dashboard for a small shop shown on a laptop screen

What You Need

You only need:

• Power BI Desktop

• An Excel file containing your sales records

For practice, use this sample data:

Order Date	Item	Category	City	Units	Revenue
02-Aug-2026	Phone Case	Protection	Karachi	30	15,000
05-Aug-2026	Fast Charger	Charging	Lahore	12	24,000
11-Aug-2026	Earbuds	Audio	Karachi	8	28,000
19-Aug-2026	Screen Guard	Protection	Islamabad	45	13,500
03-Sep-2026	Power Bank	Charging	Lahore	6	21,000
14-Sep-2026	Earbuds	Audio	Karachi	10	35,000
22-Sep-2026	Phone Case	Protection	Islamabad	25	12,500

You can copy this table into Excel and save the file before continuing.

Step 1: Decide What Your Dashboard Should Answer

Before creating charts, decide what information you actually need.

For this example, we'll answer three questions:

1. How much revenue did the shop generate?

2. Which category generates the most revenue?

3. How is revenue changing over time?

This simple approach prevents your dashboard from becoming a collection of random charts.

Step 2: Prepare Your Excel Data

Power BI works best with structured data.

Before importing your file:

• Keep one header row

• Remove merged cells

• Remove unnecessary blank rows

• Don't place totals inside the data range

• Keep dates and numbers in their proper columns

Select the data and press Ctrl + T to convert it into an Excel Table.

Give the table the name:

Sales

This makes it easier to reference the data later in Power BI.

Step 3: Import Excel Data into Power BI

Open Power BI Desktop and select:

Home → Get Data → Excel workbook

Choose your Excel file and select the Sales table.

Instead of loading it immediately, click Transform Data. This opens Power Query, where you can check and clean the data.

[Screenshot: Power BI Navigator window]

Alt text: Importing an Excel sales table into Power BI Desktop

Step 4: Check Your Data in Power Query

You don't need complicated transformations for this beginner dashboard.

Check these three things:

• Order Date → Date

• Units → Whole Number

• Revenue → Whole Number or Decimal Number

Also check for blank or incorrect records.

If necessary, use the Power Query options under Remove Rows to remove unwanted blank or error rows.

When everything looks correct, click:

Close & Apply

Your data will now be available in the Power BI report.

[Screenshot: Power Query Editor]

Alt text: Checking data types in the Power Query Editor

Step 5: Create Three Simple DAX Measures

Measures are calculations that Power BI can recalculate when users interact with the report.

Select the Sales table and choose New Measure.

Create these three measures:

Total Revenue = SUM(Sales[Revenue])

Units Sold = SUM(Sales[Units])

And:

Revenue per Unit = DIVIDE([Total Revenue], [Units Sold])

The DIVIDE function is useful because it handles division by zero more safely than a basic / calculation.

Step 6: Build the Dashboard

Now create the visuals that answer your questions.

Business Question	Visual	Fields
Total revenue?	Card	Total Revenue
Best category?	Bar chart	Category + Total Revenue
Revenue over time?	Line chart	Order Date + Total Revenue
Best city?	Donut chart	City + Total Revenue
Filter by city?	Slicer	City

Card

Start with a Card visual and add Total Revenue.

This gives you one large KPI showing overall revenue.

Bar Chart

Add a Bar Chart with:

• Category

• Total Revenue

This makes it easy to compare Protection, Charging, and Audio.

Line Chart

Add a Line Chart using:

• Order Date

• Total Revenue

For a larger dataset, you can analyze revenue by month to see longer-term trends.

Donut Chart

Add a Donut Chart using:

• City

• Total Revenue

This shows how revenue is distributed across different cities.

Slicer

Finally, add a Slicer using the City field.

Users can select Karachi, Lahore, or Islamabad and interactively filter the dashboard.

Step 7: Arrange and Format the Dashboard

A simple layout is usually easier to understand.

Put your KPI cards at the top, charts underneath, and the city slicer on the side.

For a cleaner design:

• Use one main color with one accent color

• Keep chart titles consistent

• Leave enough space between visuals

• Remove unnecessary borders and decorations

• Use clear titles such as Revenue by Category instead of automatically generated titles

Your dashboard should make the information easier to understand, not make the reader hunt for it.

[Dashboard Mockup]

Alt text: Beginner Power BI sales dashboard with KPI cards, charts, and a city slicer

Step 8: Publish Your Dashboard

When your report is ready, select:

Home → Publish

Sign in with your Microsoft account and choose the appropriate workspace.

Power BI's publishing and sharing options depend on your account, workspace, and licensing setup, so the exact sharing experience can vary between users and organizations.

3 Common Beginner Mistakes

1. Adding Too Many Visuals

More charts don't necessarily mean more useful information.

Start with a few visuals that answer specific business questions.

2. Ignoring Data Types

A date stored as text can cause problems when creating time-based charts.

Always check your data types before building the report.

3. Building Without a Purpose

If you don't know what your dashboard is supposed to explain, you can easily end up with a page full of unrelated charts.

Start with the questions, then choose the visuals.

Final Thoughts

You have now followed the basic Power BI workflow:

Excel data → Power Query → DAX measures → Visuals → Interactive dashboard

The same process can be used for many real-world reports, including sales, inventory, expenses, HR, and customer analysis.

Once you're comfortable with this dashboard, the next useful topics to learn are Power Query, data relationships, DAX, and data modeling.

If you're completely new to Power BI, don't try to learn everything at once. Build one small dashboard, understand how each visual works, and then gradually add more advanced features.