Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI First Report


Share

Build a Report in 10 Minutes

In this chapter you build a complete one-page report from the Poke Mart sales data.

The report has four visuals:

  • A card with the total sales
  • A column chart of sales by category
  • A slicer to filter the page by region
  • A line chart of sales over time

You need Power BI Desktop (see Get Started) and the practice file:

Download poke_mart_sales.xlsx

After each step, compare your numbers with the table in that step.


Step 1: Load the Data

  1. Open Power BI Desktop and start a blank report.
  2. On the Home tab, select Get data > Excel workbook.
  3. The first time, a pop-up named Introducing the new Get Data experience! may appear. Select No thanks.
  4. Find poke_mart_sales.xlsx and select Open.
  5. The Navigator window opens. Select the check box next to Sales. A preview of the data appears on the right.
  6. Select Load.

The Navigator window in Power BI Desktop with the Sales sheet selected, a preview of the Poke Mart data, and the Load button

Power BI loads all 2,740 rows.

A table called Sales appears in the Data pane on the right.

Expand it to see its ten columns.

The Transform Data button in the Navigator opens the Power Query Editor, where you can clean the data before loading it.

The Poke Mart data is already clean, so Load is enough.

Note: In the Data pane, OrderID has a sigma sign (Σ).

Power BI sees that the column holds numbers, so it plans to summarize them in visuals.

For OrderID it counts them by default.

But an order number is a label, not an amount, so it should not be summarized at all: adding up all the OrderIDs, for example, gives 6,495,170, which tells you nothing about the shop.

You will fix this in the data modeling chapter.

For now, do not use OrderID in a visual.


Step 2: Add a Card with Total Sales

A card shows one big number.

It is often the first thing people look at in a report.

  1. Click an empty spot on the canvas, so no visual is selected.
  2. In the Visualizations pane, select the Card visual.
  3. In the Data pane, select the check box next to Sales.
  4. Drag the card to the top left of the canvas.

The card shows Sum of Sales, the total of the Sales column.

VisualExpected value
Sum of Sales9,416,800

Power BI shortens big numbers on a card, so the total is shown in millions, with an M, for example 9M.

The table above has the exact value to compare with.

A card is for a quick look; when you need the exact number, use a table.


Step 3: Add a Column Chart of Sales by Category

  1. Click an empty spot on the canvas.
  2. In the Visualizations pane, select Clustered column chart.
  3. In the Data pane, select Category, then Sales.
  4. Resize the chart and place it next to the card.

Power BI puts Category in the X-axis well and Sum of Sales in the Y-axis well.

You get one column for each category:

A clustered column chart of Sum of Sales by Category next to the total sales card, with Category in the X-axis well and Sum of Sales in the Y-axis well of the Visualizations pane

Point to a column to see its exact value in a tooltip.

The tooltip shows the number without thousands separators, for example 4447200 for Balls:

CategorySum of Sales
Balls4,447,200
Medicine4,413,600
Status Healers556,000

Balls and Medicine sell almost the same.

Status Healers are a small part of the business.

This is just like a PivotTable in Excel with Category in Rows and Sum of Sales in Values, only drawn as a chart.



Step 4: Add a Slicer on Region

A slicer is a filter that sits on the canvas, where readers can see and use it.

  1. Click an empty spot on the canvas.
  2. In the Visualizations pane, select Slicer.
  3. In the Data pane, select Region.
  4. The slicer shows the three regions as a list, with a check box for each region.
  5. In the slicer, select Johto.

Every visual on the page now shows Johto only.

The card and the column chart change at once.

The card shows the total shortened, for example 3M:

Johto onlySum of Sales
Total (card)3,363,650
Balls1,647,600
Medicine1,516,300
Status Healers199,750

This is what makes Power BI different from a chart in a spreadsheet: all the visuals on a page are connected.

Clicking a column in the column chart filters or highlights the other visuals too.

To select more than one region, hold Ctrl while you click.

To remove the filter, select Johto again.


Step 5: Add a Line Chart of Sales by Date

First, select Johto in the slicer again, so the page shows all regions.

  1. Click an empty spot on the canvas.
  2. In the Visualizations pane, select Line chart.
  3. In the Data pane, select Date, then Sales.
  4. Make the chart wide, below the other visuals.

Look at the X-axis well.

Power BI did not add just the Date column.

It added a date hierarchy with four levels: Year, Quarter, Month and Day.

Power BI builds this hierarchy for every date column automatically.

The chart starts at the top level, so it shows one point per year:

YearSum of Sales
20244,393,200
20255,023,600

Sales grew from 2024 to 2025. To see more detail, point to the chart and use the drill arrows at the top or bottom of the visual.

Select Expand all down one level in the hierarchy to show each quarter of each year:

A line chart of Sum of Sales by Year and Quarter, with the drill icons shown on the visual and the date hierarchy Year, Quarter, Month, Day in the X-axis well

YearQuarterSum of Sales
2024Qtr 1852,950
2024Qtr 21,119,400
2024Qtr 31,223,600
2024Qtr 41,197,250
2025Qtr 1977,950
2025Qtr 21,197,800
2025Qtr 31,452,100
2025Qtr 41,395,750

Select Drill up to go back to years.

Now try the slicer again: select Johto, and the line chart shows Johto only (1,612,450 in 2024 and 1,751,200 in 2025).


Step 6: Save Your Report

  1. Select File > Save as. On a new report that was never saved, Save is grayed out.
  2. The Save a copy page opens. Under Other, select Browse this device.
  3. The Windows Save As dialog opens. Choose a folder, and name the file poke_mart_report.
  4. Select Save.

Power BI Desktop saves the report as a .pbix file.

The file holds everything: the data, the model and the report pages.

You can close Power BI Desktop and open the file again later.

Your finished report should look like this, here with Johto selected:

The finished Poke Mart report in Power BI Desktop with Johto selected in the Region slicer: the card, the column chart and the line chart all show Johto only

Good job! You have built your first interactive Power BI report.


What You Learned

  • Get data > Excel workbook and the Navigator load a sheet into Power BI.
  • Power BI summarizes number columns automatically, even ID columns where that makes no sense.
  • A card shows one number, and a column chart compares categories.
  • A slicer filters every visual on the page.
  • Date columns get a Year, Quarter, Month and Day hierarchy that you can drill into.

In the next chapters you will clean data with Power Query, build a data model with relationships and DAX measures, and publish your report to the Power BI service.



Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.