If you already track orders in Excel, you have what you need to practice building a Power BI dashboard. Start with a small workbook and three questions: How much did we sell? How many orders did we record? Which channel accounted for the most revenue?
To build your first Power BI dashboard from an Excel file, create an interactive report in Power BI Desktop, verify the figures, then publish and pin visuals if you need a dashboard in the Power BI service. In Microsoft’s terminology, the report is where you build charts and slicers. A dashboard is a single page of tiles in the online service. You can stop at the report if you want a local, interactive view. Microsoft Learn overview of Power BI dashboards
1. Turn your Excel data into a named table
Paste the sample data below into Excel starting in cell A1. Each row represents one order, and each amount is in U.S. dollars. If the text lands in one column, use Data → Text to Columns and choose a comma as the delimiter, or import it as a CSV.
OrderID,OrderDate,Channel,Revenue
A-101,2026-01-05,Online,120
A-102,2026-01-14,In store,80
A-103,2026-01-26,Online,200
A-104,2026-02-03,In store,100
A-105,2026-02-12,Online,150
A-106,2026-02-24,In store,50
A-107,2026-03-08,Online,90
A-108,2026-03-18,In store,110
Select the data, choose Insert → Table, and confirm that the table has headers. In Table Design, name it Sales. Save the workbook as Sales Practice.xlsx.
For your own workbook, give every column a unique header. Keep one kind of record per row and put totals or notes outside the table. If you include an Excel total row as an ordinary data row, Power BI can add it to the individual sales and inflate the result.
2. Import the table into Power BI Desktop
Open Power BI Desktop on a supported Windows computer. Select Home → Get data → Excel workbook and open the saved file. In Navigator, choose the named Sales table. If you see the worksheet as well, select only the table so you import the intended rows. Choose Transform data to check the preview in Power Query. Microsoft Learn tutorial on importing Excel data · Power BI Desktop download and requirements
| Column | Data type | What to check |
|---|---|---|
| OrderID | Text | Each order ID appears once in this sample. |
| OrderDate | Date | The date is interpreted correctly. If your own dates use a different regional format, check the locale used during conversion. |
| Channel | Text | Channel names are spelled consistently and have no stray spaces. |
| Revenue | Fixed decimal number | The amounts are numeric. The example uses a single currency. |
Confirm that the preview has eight records and no errors. Select Close & Apply to load the table into the report model. Microsoft Learn guide to getting data with Power Query
3. Create two measures for sales and orders
In Report view, select the Sales table in the Data pane. Use New measure and enter each formula separately. Measures recalculate as you change the report filters.
Total Revenue = SUM(Sales[Revenue])
Total Orders = DISTINCTCOUNT(Sales[OrderID])
Select Total Revenue and set its display format to currency. Format Total Orders as a whole number. The sample has no blank order IDs. For a real workbook, fix missing IDs before relying on the count. If one order spans several product rows, a distinct count still counts the order once, but the revenue column should contain each line’s amount so the report can sum it correctly.
4. Build an interactive sales overview
Add the visuals below to one report page. Depending on your Power BI Desktop version, you may add fields through the visual’s field wells or the on-object controls.
| Visual | Fields to use | What it shows |
|---|---|---|
| Card | Total Revenue | Combined revenue for the current selection |
| Card | Total Orders | Number of distinct orders for the current selection |
| Clustered bar chart | Channel on the category axis, Total Revenue on the value axis | Sales by channel |
| Line chart | OrderDate on the horizontal axis, Total Revenue on the value axis | Sales over time |
| Slicer | Channel | Lets you filter the report to one channel |
For the line chart, select the Date hierarchy if it’s available and drill to the month level across the date range. If your model doesn’t offer a hierarchy, add a start-of-month date column in Power Query using the order date, then use that column on the axis. If your own data spans several years, make the year visible so January from one year stays distinct from January in another.
Name the page Sales Overview. Keep the two cards together, then place the trend and channel charts where readers can compare them without scrolling around the canvas.
5. Verify the numbers against Excel
Use the table below to check the unfiltered view and both channel selections. Clear the slicer before checking the full result.
| Selection | Expected revenue | Expected orders |
|---|---|---|
| All channels | $900 | 8 |
| Online | $560 | 4 |
| In store | $340 | 4 |
The monthly totals should be January $400, February $300, and March $200. If a card is wrong, check the imported table, the filters, and whether Revenue loaded as a number. If months look wrong, check how Power Query interpreted OrderDate and which level of the date hierarchy the chart displays. Save the report as a .pbix file once the checks pass.
6. Publish and pin visuals to a dashboard
If you need an online dashboard, sign in to the Power BI service and use Home → Publish in Desktop. Choose a workspace where you’re allowed to publish. Publishing uploads the report and its semantic model, which contains the imported data in this example. Use the practice workbook for your first try and check permissions before publishing real business data. Microsoft Learn guide to publishing from Power BI Desktop
In the service, open the published report. Hover over a visual, select the pin option, and choose New dashboard or an existing dashboard. Repeat for the visuals you want on that page. For a view that uses slicers, keep the report available as the main workspace for exploration. Microsoft also documents how to pin a live report page, which behaves differently from individually pinned tiles. Verify workspace and sharing requirements before planning to send the dashboard to colleagues. Microsoft Learn guide to creating a dashboard from a report · Microsoft Learn guide to getting started in the Power BI service
7. Test what happens when you add a new Excel row
Add a ninth order inside the Excel table with ID A-109, date 2026-03-25, channel Online, and revenue 100. Save the workbook, return to Power BI Desktop, and choose Home → Refresh. With no filter applied, you should see $1,000 total revenue and 9 orders. March should now show $300.
The published report uses the service’s copy of the model. To update it manually for this exercise, refresh in Desktop and republish. For scheduled refresh, check where your workbook is stored and how the model connects to it. A local file source can require a configured gateway that can reach the file. Moving a workbook to OneDrive or SharePoint doesn’t update an existing local-file connection by itself. Set up a supported connection to the cloud source and verify refresh in the service. Microsoft Learn guide to Power BI data refresh
Frequently asked questions
1. Can I build the report without publishing it?
Yes. You can build, save, and open the report in Power BI Desktop. Publishing is needed for the online workflow covered here, including creating a dashboard with pinned tiles.
2. Can I use Power BI Desktop on a Mac?
Microsoft lists Windows as the supported operating system for Power BI Desktop. On a Mac, you can use the Power BI service in a supported browser for the features your account allows, or use a supported Windows environment for the Desktop steps in this tutorial. Power BI Desktop requirements
3. Why did my new Excel rows fail to appear?
Check that the rows are part of the named Excel table and that you saved the source workbook. Then refresh the report. If you’re viewing it online, verify that the published model refreshed successfully and still points to the intended source.
4. Do I need DAX for a first Power BI dashboard?
You can make a basic chart using Power BI’s built-in summarization options. A named measure is useful when several visuals should calculate the same number consistently, as the revenue card and both charts do here.
5. Can I share the dashboard with my team?
That depends on your workspace, license, and organization settings. Check the sharing requirements and the intended recipients’ access. For internal data, use authenticated sharing with the intended people. Publish to web makes content public. Microsoft Learn guidance on Power BI service access · Microsoft Learn guidance on Publish to web
Conclusion
Start with one clean Excel table and a report that answers three questions about your sales. Check the totals with and without a filter, then add a test row and refresh. Once you’ve seen the numbers update as expected, use the same workflow with your own workbook and publish if you need an online dashboard.


