Power BI Dashboard From Excel: 10 Easy Steps

Learn to create a Power BI dashboard from Excel in 10 easy steps. Import data, build charts, add filters, and publish interactive reports.

Microsoft Excel is among the most popular tools that are used to organize business information. But with large volumes of data in spreadsheets, the interpretation and presentation of findings becomes tough.

The Microsoft Power BI software assists users to convert their spreadsheet data into an interactive report.

Organizations can use Power BI to analyze sales performance, analyze financial metrics, compare regional data and trends with visual reporting.

The best part is that one can learn to use Power BI with a simple Excel spreadsheet.

Programming skills are not necessary for creating your first report.

Below is the guide that will help you create a Power BI dashboard from Excel, including data preparation, spreadsheet loading, visualization, filtering and publishing.

What Is Power BI and How Does It Work With Excel?

Power BI is Microsoft’s business intelligence and data visualization platform.

It helps in connecting to data sources, manipulating data, building models for analysis, and building interactive reports.

The difference between the chart in the Excel worksheet and the Power BI report is the way in which the user can navigate the information by means of filtering.

For example, the sales manager can analyze the revenue generated by different products at different places and in different months using the Power BI report.

The manager no longer needs to prepare different charts for each comparison as he/she can utilize a single interactive report.

Power BI is particularly beneficial to companies that require repeated reporting and reliable business metrics.

For broader industry context, explore 7 Data Analytics Trends Businesses Should Watch in 2026.

What Is the Difference Between a Power BI Report and Dashboard?

It is vital to comprehend Microsoft terminology before beginning.

A Power BI report includes one or multiple pages of visualization created based on a semantic model.

A Power BI dashboard refers to a single-page canvas in the Power BI service wherein the tiles can be pinned from reports.

This is important to note because the Power BI Desktop application is mostly used for creating reports.

Dashboards can be built using the Power BI service.

In this tutorial, you will start by creating a report from Excel and then see how to convert the visuals in it into a dashboard.

Step 1: Prepare Your Excel Dataset

The first step is organizing your spreadsheet.

For this example, imagine a retail company tracking monthly sales.

Your Excel file could contain the following columns:

This is illustrative sample data.

Before importing the spreadsheet, check that each column has a clear heading.

Remove unnecessary blank rows and avoid merged cells inside the dataset.

Make sure dates are stored as dates and numeric values are formatted consistently.

If possible, select your dataset in Excel and convert it into a table using the Insert > Table option.

Save the workbook in .xlsx format.

Proper data preparation reduces errors during analysis.

Step 2: Install Power BI Desktop

Power BI Desktop is the main Windows application used to develop Power BI reports.

Visit the official Microsoft Power BI Desktop download page.

Download and install the application on a supported Windows computer.

Once installation is done, open Power BI Desktop.

Power BI offers the following ways of importing, modeling, and visualizing the data.

For those who have Mac OS, it is to be noted that no desktop version of Power BI is available for Mac OS. There are two other ways in which Power BI can be accessed.

Step 3: Import Excel Data Into Power BI

Open Power BI Desktop and follow these steps:

1. Select Home > Get Data.
2. Choose Excel workbook.
3. Browse to your saved Excel file.
4. Select the worksheet or table containing your data.
5. Review the preview in the Navigator window.
6. Choose Transform Data to inspect and clean the dataset.

Power BI opens Power Query Editor when you choose Transform Data.

This tool allows you to prepare information before loading it into your analytical model.

If your spreadsheet is already clean, you can load it directly.

However, reviewing the data first is generally a good practice.

Step 4: Clean Data Using Power Query

Power Query helps transform data without requiring extensive programming knowledge.

Common operations include removing duplicates, changing data types, filtering records and renaming columns.

For the retail example, confirm that:

• Date is assigned a date data type.
• Sales is assigned an appropriate numeric type.
• Quantity is stored as a whole number.
• Product and Region are stored as text.
• Blank or invalid records are reviewed.

You can also remove columns that are unnecessary for the report.

After completing your changes, select Close & Apply.

The Power BI then imports the processed data into its semantic model.

Note that cleaning the data does not mean removing abnormal values.

It might happen that those abnormal records could be genuine business transactions.

Step 5: Create Your First Power BI Visualizations

After loading the dataset, open Report view.

Power BI provides several visualization types.

Start with a simple sales report containing three charts.

Create a Sales by Region Chart

Choose a clustered column chart.

Place Region on the X-axis and Sales in the Y-axis field.

Ensure that Sales is aggregated using Sum.

This chart allows you to compare revenue across different regions.

Create a Sales by Product Chart

Insert a bar chart.

Add Product as the category and Sales as the value.

This visualization helps identify which products contribute the most revenue.

Create a Monthly Sales Trend

Insert a line chart.

Use Date on the X-axis and Sales on the Y-axis.

Group dates at an appropriate monthly level.

A line chart helps users understand whether sales are increasing, decreasing or fluctuating over time.

Step 6: Add KPI Cards

KPIs give an instant overview of business metrics that are relevant.

For the sample report, KPIs to be used will be total sales, total quantity, and average sales per transaction.

In order to show total sales, you should insert a card visual and add the Sales field using Sum aggregation type.

You can also create a DAX measure:

Total Sales = SUM(SalesData[Sales])

Replace SalesData with the actual name of your imported table.

DAX refers to Data Analysis Expressions that are used to perform calculations in Power BI.

It is unnecessary for beginners to master DAX instantly; however, having knowledge of some simple measures will help improve consistency in reporting.

Step 7: Add Interactive Slicers

Slicers enable filtering of report information.

For instance, a sales dashboard can contain slicers for Region, Product, and Date.

The process involves choosing the Slicer visualization tool and then adding the field.

Once users choose a particular region, all other visualizations will change according to the data they have selected.

Interactivity is one of the most important functions of Power BI.

Users need to make sure that they do not add any filters which might clutter the dashboard.

Step 8: Format Your Report

Professional reports should contain information that is consistent, easy to understand, and navigable.

Make sure to include informative chart titles and use legible fonts.

Have a restricted number of colors and apply them consistently throughout the report.

Put KPIs at the top of the report.

If similar charts are located on the same page, they should be consolidated.

Proper formatting of numbers should be applied in currency values, percentages, and numerical values.

For example, the sales value figure should include the currency symbol when the value is monetary in nature.

The dashboard should appropriately answer business questions.

Step 9: Publish Your Report

After completing the report, save your Power BI Desktop file.

Then select “Publish” from the Home ribbon.

Log in to your Power BI account and select the target workspace.

The report along with its semantic model will be published to Power BI service.

Publishing and Sharing options depend upon your account privileges and licensing.

Microsoft provides additional instructions in its official Power BI report creation guide.

Step 10: Publish Your Power BI Dashboard From Excel

Open the published report in the Power BI service.

Locate a visual you want to include on your dashboard.

Use the visual’s Pin to dashboard option where available.

You can create a new dashboard or select an existing one.

Repeating the procedure will help in creating vital charts and key performance indicators.

The dashboard can incorporate multiple report tiles hence its application in executive summaries.

A beginner should start with a basic dashboard containing total sales figures, performance regionally and monthly.

Common Power BI Mistakes to Avoid

One common mistake is importing poorly structured spreadsheets.

Another is using too many charts without considering the questions users need answered.

Beginners should also pay attention to aggregation settings.

For example, averaging out revenues where the business issue is about total revenue can lead to misleading conclusions.

Some other mistakes could be having different dates format, not labeling things clearly, and even sending the reports without checking for the proper permissions.

Running the report through some test questions will be helpful.

Conclusion

Building a Power BI Dashboard using an Excel sheet can be one of the easiest methods to start getting familiar with Business Intelligence.

The process involves data preparation in spreadsheets, data importation to Power BI, data cleaning, creation of visuals and report publication.

After making the report accessible on the Power BI platform, end users can pin key visuals to the dashboard.

With practice, beginners will be able to progress from preparing simple sales reports to more complicated analytical reports.

The key skill is not the ability to create complicated graphs. The key skill is the ability to convey correct information in an understandable manner.

Frequently Asked Questions (FAQs)

1. Can I create a Power BI dashboard using Excel?

Yes. You can take Excel data. Bring it into Power BI build a report and add visuals to a dashboard in the Power BI service.

2. Is Power BI free for beginners?

Power BI Desktop can be downloaded for free. Some features like sharing and working with others need licenses.

3. Do I need coding knowledge to use Power BI?

No. New users can bring in data make charts and use filters without any coding. DAX and other technical skills help with complex work.

4. Can Power BI update data from Excel?

Yes. How often data refreshes depends on where the Excel file’s stored, how the connection is set up and what Power BI tools are available.

5. What is the difference between Excel and Power BI?

Excel is a tool, for spreadsheets while Power BI is built for creating data models making reports and working with business intelligence.