Module 1: Getting started · Lesson 1.4 · about 20 min
Your first report in 15 minutes
Load the Northbay files into Power BI Desktop, connect the tables, write one measure and build a page with a card, a bar chart, a line chart and a slicer.
Module 1 · about 20 minutes · needs: Power BI Desktop and the five CSV files from Lesson 1.2. You’ll build a one-page report and see a measure respond to filters.
1. Why this matters
The fastest way to understand Power BI is to make one small report end to end. Everything after this lesson goes deeper into one of these steps.
2. Load the data
- Home > Get data > Text/CSV, pick
northbay-sales.csv, then Load (not Transform for now). - Repeat for product, store, date and targets. In the Data pane you now see five tables.
- Open Table view and click Sales: check that Date shows as a date and Amount as a number (a ∑ icon). If not, Lesson 2.2 fixes types.
3. Connect the tables
- Open Model view. Power BI may already have guessed some relationships; check each line.
- Drag
Sales[ProductKey]ontoProduct[ProductKey]. Do the same for StoreKey toStoreand Date to'Date'[Date], andTargets[StoreKey]toStore[StoreKey]. - Each line should show 1 at the dimension end and * at the Sales end, with an arrow pointing to Sales. Your model now matches the diagram in Lesson 1.2.
- Select the Date table, then Table tools > Mark as date table, and choose the Date column.
4. Write a measure
On the Home ribbon, New measure, type:
Total Sales = SUM(Sales[Amount])
Press Enter. In the measure’s Measure tools ribbon, set the format to Currency with 0 decimals. Try the same measure right here:
Press Run. Then change Split by to Store[Store] and run it again. Which store sold the most?
Press Run to see the result.
5. Build the page
- Card: pick the Card visual, drop
Total Salesinto it. - Bar chart: clustered bar chart,
Product[Category]on the Y-axis,Total Saleson the X-axis. - Line chart:
'Date'[YearMonth]on the X-axis,Total Saleson the Y-axis. - Slicer: a slicer with
Store[Region]. - Click a region in the slicer, then a bar in the bar chart. Every visual changes: the one measure is being worked out again for whatever is selected.
Principle
Principle: a visual never stores numbers. Each time you click, Power BI builds the filter context for every cell (slicer selection + the bar you clicked + the row or axis of that cell) and evaluates the measure inside it.
Try it: with nothing selected, read the card. Select West in the slicer and read it again. Same measure, different filter context, different answer.
6. Worked example
Check your numbers. With no filters, the card shows the total of every order line. In the editor above, split by nothing (one total) and compare. Then split by Product[Category]: the four category values should add up to the total. Checking that parts add up to the whole is the first habit of a careful BI developer.
7. Practice
- Change the bar chart to show stores instead of categories.
- Add a second card with
Units = SUM(Sales[Quantity]). - Save the file as
northbay.pbix. You’ll keep building on it through the course.
Answers
- Replace Product[Category] on the Y-axis with Store[Store]. Queen Street should be the top bar.
- New measure >
Units = SUM(Sales[Quantity]), then a Card visual with Units. - File > Save as.
Check yourself
Your ticks stay in this browser. Save them as a file on the course home.
Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. Power BI changes every month: menu names can move, so check Microsoft Learn if a button is not where the lesson says. The practice editor runs in your browser; nothing you type is sent anywhere.