Your First Report

What You'll Learn

• Create your first Power BI report from scratch
• Load sample data
• Build basic visualizations
• Understand visual interactions
• Format and customize visuals

Getting Sample Data

We'll use Excel sample data for this first report.

Download Sample Data: Power BI Desktop > Home > Get Data > Samples > Financial Sample

Or create a simple Excel file with this data:

Product, Sales, Region

• Laptop, 50000, East
• Phone, 35000, West
• Tablet, 28000, East
• Monitor, 15000, West

Step 1: Load Data

1. Open Power BI Desktop
2. Home > Get Data > Excel
3. Browse to your Excel file
4. Select the table/sheet
5. Click Load

You'll see the table appear in the Fields pane!

Step 2: Create Your First Visual

Let's make a bar chart showing Sales by Product.

Steps:

1. Click on the Report View (left sidebar)
2. From Visualizations pane, click Clustered Bar Chart
3. Drag Product to the Y-axis
4. Drag Sales to the X-axis

Result: A bar chart appears showing sales for each product!

Step 3: Add a Second Visual

Let's add a pie chart for Sales by Region.

Steps:

1. Click empty space on canvas (deselect first chart)
2. Click Pie Chart in Visualizations
3. Drag Region to Legend
4. Drag Sales to Values

Now you have two visuals!

Step 4: Format Your Visuals

Make your charts look professional.

Chart Title:

1. Select the bar chart
2. Visualizations > Format (paint roller icon)
3. Expand Title
4. Toggle On
5. Change text to "Sales by Product"

Colors:

1. Expand Data colors
2. Choose your color scheme

Data Labels:

1. Expand Data labels
2. Toggle On
3. Now values appear on bars!

Step 5: Add a Card Visual

Cards display a single important number (KPI).

Create Total Sales Card:

1. Click empty space
2. Select Card visual
3. Drag Sales to Fields

This shows total sales across all products!

Step 6: Arrange Your Report

Make it look clean and organized.

Tips:

• Resize visuals by dragging corners
• Drag to reposition
• Use View > Gridlines to align
• Leave white space - don't crowd

Suggested Layout:

• Sales by Product Bar Chart (left)
• Sales by Region Pie Chart (right)
• Total Sales Card (bottom)

Understanding Visual Interactions

Click on a bar in your bar chart. Notice:

• The pie chart filters to that product
• The card updates to show that product's sales

This is cross-filtering - visuals interact automatically!

Control Interactions: Format > Edit Interactions > choose how visuals interact

Step 7: Add a Slicer

Slicers are filters users can control.

Add Region Slicer:

1. Click Slicer visual
2. Drag Region to Field
3. Now you can click East/West to filter all visuals!

Step 8: Add a Title

Make your report look professional.

Steps:

1. Insert > Text Box
2. Type "Sales Dashboard"
3. Increase font size (20-24pt)
4. Make it bold
5. Position at the top

Your First Report Complete!

You now have:

• Bar chart showing sales by product
• Pie chart showing sales by region
• Card showing total sales
• Slicer to filter by region
• Professional title

Save Your Work

File > Save As

• Choose a location
• Name it "My First Report.pbix"
• .pbix is Power BI Desktop file format

Try This Challenge

Add these enhancements:

1. Change the theme (View > Themes)
2. Add background color to report
3. Create a table showing all data
4. Add data labels to pie chart

Next Module Preview

In Module 1, you'll learn:

• Connecting to real data sources
• Cleaning data with Power Query
• Transforming and shaping data
• Building proper data models

Congratulations!

You've created your first Power BI report!

This is just the beginning. Power BI can handle millions of rows, complex calculations, and sophisticated visuals.

Tip: Practice recreating this report from memory. Repetition builds muscle memory!