Power BI Building Your First Report
A report in Power BI is a collection of visuals — charts, tables, cards, and slicers — arranged on one or more pages. Each visual shows a different view of your data. Together, they tell the story of your data in a way that any viewer can understand at a glance.
This topic walks you through building a complete basic report from start to finish using a sample sales dataset.
Start with a Clear Question
Before placing any visual on the canvas, decide what question your report needs to answer. A report without a purpose becomes a collection of random charts that confuses viewers instead of informing them.
Good report questions are specific. Instead of "show me sales data," ask:
- Which product category generated the most revenue this year?
- How does monthly revenue compare to the same month last year?
- Which salesperson exceeded their target, and which did not?
Once you have a clear question, you know which data fields to use and which visual types will answer the question most effectively.
Step 1 — Load Your Data
Click Get Data in the Home tab, connect to your data source (Excel, database, or any other source), and load your tables. For this walkthrough, assume you have a Sales table with columns for Date, Product, Category, Region, Salesperson, Revenue, and Profit.
After loading, switch to Data View to confirm the data looks correct — column names are clear, data types are correct, and no obvious errors appear in the preview.
Step 2 — Add Your First Visual
Switch to Report View (the bar chart icon on the left). The canvas is blank with a new page tab at the bottom labeled "Page 1."
Click anywhere on the blank canvas to make sure nothing is selected. In the Visualizations pane on the right, click the Clustered Bar Chart icon. A blank chart placeholder appears on the canvas.
In the Fields pane on the far right, find the Sales table and expand it. Drag the "Category" field and drop it into the Y Axis well in the Visualizations pane. Then drag "Revenue" into the X Axis well. The bar chart immediately fills with bars showing revenue for each product category.
Step 3 — Add a Card Visual for a Key Number
Click on an empty area of the canvas to deselect the bar chart. In the Visualizations pane, click the Card icon (a rectangle with a number display). A blank card placeholder appears.
Drag "Revenue" from the Fields pane into the Fields well of the card. The card now shows the total revenue as a large number — a clean, prominent way to display a key metric.
Resize and reposition the card by clicking and dragging its edges and corners. Place it in the top-left corner of the canvas as a headline number.
Step 4 — Add a Slicer for Filtering
A slicer lets report viewers filter all visuals on the page with a single click — no technical knowledge required on their part.
Click an empty area of the canvas. In the Visualizations pane, click the Slicer icon. A blank slicer placeholder appears. Drag "Region" from the Fields pane into the Field well of the slicer. A list of region names appears in the slicer.
Click "North" in the slicer. Every visual on the page — the bar chart and the card — instantly updates to show only North region data. Click "South" and everything updates again. This is the power of slicers — one click, everything changes.
Step 5 — Add a Line Chart for Trends
Click an empty area of the canvas. Select the Line Chart visual from the Visualizations pane. Drag "Date" into the X Axis well and "Revenue" into the Y Axis well.
Power BI groups dates by year automatically when you first add a date field. Click the expand drill icon (a forked downward arrow) on the visual to drill down to month-level data. Now the line chart shows revenue trends by month, revealing seasonal patterns or growth trends over time.
Step 6 — Arrange Visuals Logically
Good report layout follows reading patterns. Most viewers read from top to bottom and left to right. Place your most important number (the Total Revenue card) in the top-left. Put filtering tools (slicers) on the left side or top. Place charts in the main body of the report.
Align visuals using the Format tab in the ribbon. Select multiple visuals by holding Shift and clicking each one. Use Align and Distribute options to space them evenly and align their edges — this gives the report a professional, organized appearance.
Step 7 — Add a Page Title
In the Insert tab, click Text Box. A text box appears on the canvas. Type your report title — for example, "2024 Sales Performance Overview." Select the text, increase the font size to 20 or 24, and make it bold. Place this text box at the very top of the canvas as the report header.
Step 8 — Add a Second Page
At the bottom of the canvas, click the plus (+) icon next to the existing page tab. A new blank page appears. Name it by double-clicking the page tab — call it "By Salesperson" or "Regional Detail" depending on what you plan to build there.
Each page in a report is a separate canvas. Slicers placed on one page do not automatically apply to other pages unless you configure cross-page filtering. Keep related visuals on the same page.
What a Complete Report Looks Like
After following these steps, your report page has:
- A title at the top identifying what the report shows
- One or more Key Metric cards showing headline numbers
- A bar chart showing performance by category
- A line chart showing trends over time
- A region slicer letting viewers filter all visuals instantly
This structure answers the core question — how is revenue performing across categories, regions, and time — in a single page view that any viewer can understand without explanation.