Building Your First Power BI Dashboard from Excel Data

Download and Install Power BI Desktop

Power BI Desktop is the free application where you build all your reports. It runs on Windows only.

1. Go to powerbi.microsoft.com
2. Click Products → Power BI Desktop → Download Free
3. Or download from the Microsoft Store (search "Power BI Desktop") — recommended as it auto-updates
4. Install and open — you see 3 panes: Report view (canvas), Data view (tables), Model view (relationships)
5. Sign in with your Microsoft account (optional for personal use, required for sharing)

The 3 views you need to know:

• Report view — where you build your dashboard (drag visuals onto the canvas)
• Data view — see your raw data tables, add calculated columns
• Model view — see and create relationships between tables

Prepare Your Excel Data

Power BI works best with clean, structured data. Before connecting, make sure your Excel file is ready.

Golden rules for Power BI-ready Excel data:

• Data must be in a proper Table (Ctrl+T in Excel) — not a plain range
• Row 1 = headers only — no merged cells, no blank header cells
• No blank rows in the middle of data
• No subtotal rows inside the data — only raw transaction rows
• Dates must be real Excel dates — not text strings like "01 Apr 2026"
• Numbers must be numbers — not text formatted to look like numbers
• One type of data per column — all text or all numbers, never mixed

Ideal column structure for a sales dashboard:

• Date (real date format)
• OrderID (unique identifier)
• CustomerName (text)
• Region (text — North/South/East/West)
• Product (text)
• Category (text)
• Quantity (whole number)
• UnitPrice (decimal)
• TotalAmount (decimal)
• SalesRep (text)

Connect Excel to Power BI

Now open Power BI Desktop and connect to your Excel file.

1. Open Power BI Desktop → click Get Data (Home tab) → Excel Workbook
2. Browse to your Excel file → click Open
3. The Navigator pane appears — showing all Tables and Sheets in your file
4. Check the Tables you want to import (tick the box next to each table name)
5. Click Transform Data if you need to clean (opens Power Query Editor)
6. Or click Load to import directly if data is already clean

Power Query Editor — quick clean before loading:

• Remove columns you do not need (right-click column → Remove)
• Change data types: click the icon left of column name → select Number, Date, Text
• Filter rows: click dropdown arrow on any column → filter unwanted values
• Click Close & Apply when done — data loads into Power BI

Create Your First Visuals

Now the fun begins. In Report view, you build your dashboard by adding visuals to the canvas.

How to add a visual:

1. Click anywhere on the blank canvas
2. In the Visualizations pane (right side), click the visual type you want
3. A blank visual placeholder appears on the canvas
4. Drag fields from the Fields pane (far right) into the visual's field wells
5. Resize by dragging corners, move by dragging the title bar

Essential first visuals to build:

Add Slicers for Interactive Filtering

Slicers in Power BI work just like Excel Slicers — but they automatically filter ALL visuals on the page at once, with no extra setup needed.

1. Click an empty area of the canvas
2. Click the Slicer icon in the Visualizations pane (looks like a funnel)
3. Drag a field to the Field well — e.g., "Region", "Year", "Product Category"
4. The slicer appears as a list by default
5. Click the dropdown arrow on the slicer → change to: List, Dropdown, Between (for dates/numbers), or Tile

Now click any slicer value — watch all charts on the page filter instantly. No connections to set up, no Report Connections dialog — Power BI does it automatically.

Date slicer — range selector:

• Add a slicer with your Date field
• Change to "Between" style
• Two date pickers appear — set start and end date
• Drag the handles to select any date range

Create Measures with DAX

DAX (Data Analysis Expressions) is Power BI's formula language. It is similar to Excel formulas but works on entire columns and tables rather than individual cells. For your first dashboard, you only need a few basic measures.

How to create a measure:

1. Home tab → New Measure
2. Type your DAX formula in the formula bar
3. Press Enter — the measure appears in the Fields pane
4. Drag it to any visual just like a regular column

Essential beginner DAX measures:

• Total Sales = SUM(SalesData[TotalAmount])
• Total Orders = COUNTROWS(SalesData)
• Avg Order Value = AVERAGE(SalesData[TotalAmount])
• Profit Margin % = DIVIDE(SUM(SalesData[Profit]), SUM(SalesData[Revenue]), 0)
• YTD Sales = TOTALYTD(SUM(SalesData[TotalAmount]), DateTable[Date])

Use these measures in Card visuals to create your KPI numbers at the top of the dashboard.

Format and Design Your Dashboard

A working dashboard and a professional dashboard are two different things. Spend 15 minutes on formatting to make a lasting impression.

Format individual visuals:

• Click a visual → click the Format visual paintbrush icon in Visualizations pane
• Visual tab: change colours, data labels, axis labels, title text
• General tab: set exact size and position, add shadow, background

Dashboard-level design:

• View tab → Themes → choose a colour theme for the whole report
• View tab → Wallpaper → set background colour or image
• Insert → Text Box → add a dashboard title at the top
• Insert → Shapes → add rectangles behind sections for visual grouping
• Insert → Image → add your company logo

Design best practices:

• Maximum 3 colours — primary, secondary, accent
• KPI Cards at the top row, charts in the middle, detail tables at the bottom
• Slicers at the top or left side — clearly visible
• Same font size for all chart titles (14pt), same size for all axis labels (10pt)
• Use data labels sparingly — only on bar charts where exact values matter
• Remove gridlines and borders that add clutter without adding information

Publish to Power BI Service and Share

Once your dashboard is ready, publish it online so others can view and interact with it — from any device, anywhere.

Publishing your report:

1. Home tab → Publish
2. Sign in with your Microsoft work or school account (required)
3. Choose a workspace — "My Workspace" for personal use
4. Click Select — Power BI uploads the report and data
5. Click the link to open it in Power BI Service (your browser)

Sharing your report:

• In Power BI Service → click Share → enter email addresses
• Or click File → Publish to web for a public embed link (no login required)
• Embed the link in your website, SharePoint, or Teams channel
• Set up scheduled refresh so the report auto-updates from your Excel file

Set up auto-refresh:

• In Power BI Service → Datasets → click the three dots (⋯) → Schedule Refresh
• Connect to your data source (Excel must be on OneDrive or SharePoint for scheduled refresh)
• Set refresh frequency: Daily, Every hour, or custom schedule
• Report updates automatically — no manual publishing needed