How to Build a Basic Power BI Dashboard
.svg){kind=small}
How to Create a Power BI Dashboard
In Power BI, a report and a dashboard are not quite the same thing. You build report pages and visuals in Power BI Desktop, publish the report to the Power BI Service, and then create a dashboard by pinning visuals or a report page to it.
If you are a beginner, the simplest process is: connect to your data in Power BI Desktop, clean it, build your report visuals, publish the report, then pin the most important visuals to a dashboard in the Power BI Service.
What Is a Power BI Dashboard?
A Power BI dashboard is a single-page view in the Power BI Service that brings together important visualisations as tiles. It is designed to give users an at-a-glance view of key information and can contain tiles from one or more reports.
Most filtering, slicing, cross-highlighting and drill-down happens within Power BI reports. Dashboard tiles are best used as a high-level summary and can take users back to the underlying report for deeper analysis.
Step 1: Install Power BI Desktop
Start with Power BI Desktop, Microsoft's main tool for creating Power BI reports. It is free to download from the Microsoft website or Microsoft Store.
Once installed, open Power BI Desktop and you will see a blank report canvas where you can begin building your analysis.
Step 2: Connect to Your Data
Power BI can connect to hundreds of data sources, including Excel, CSV, SQL databases, SharePoint and cloud services. For a simple first report, an Excel file is a good place to start.
- Click Home > Get Data > Excel.
- Browse to your file and select it.
- Choose the worksheet or table you want to use.
- Click Load.
Your data is now available for use in the report.
Step 3: Prepare and Clean the Data
Data often needs some tidying before it is ready for reporting. Power BI includes Power Query Editor, which lets you clean and transform data before loading it into your model.
- On the Home tab, click Transform Data.
- In the editor, you can:
- Rename columns
- Change data types
- Remove duplicates
- Split or merge columns
- Filter unwanted rows
- When finished, click Close & Apply.
Well-prepared data makes it much easier to create accurate reports and dashboards.
Step 4: Create Your First Report Visual
Now you can start turning your data into visuals.
- Click on the report canvas.
- Choose a visual type such as a bar or column chart.
- Add a numeric field such as Sales to the visual.
- Add a category such as Region to break the values down.
You will immediately see a visual summarising your data.
Step 5: Add More Visuals
A useful report page normally contains several visuals that work together. For example, you might add:
- A line chart to show trends over time.
- A map for location-based data.
- A card to highlight a key number such as total sales.
- A table or matrix for more detailed information.
Arrange the visuals clearly so the most important information is easy to find.
Step 6: Add Filters and Slicers
Power BI reports are interactive, so users can explore the data rather than simply viewing a static page.
- Filters let you restrict the data shown at visual, page or report level.
- Slicers give users an on-page control for filtering the report.
For example, you could add a Year slicer so viewers can switch between different periods.
Step 7: Format and Design Your Report
A well-designed Power BI report is easy to read and helps the audience focus on the information that matters.
- Keep the page simple and avoid clutter.
- Use consistent formatting.
- Group related visuals together.
- Add clear titles and labels.
- Use white space to separate sections.
- Make the most important KPIs visually prominent.
Step 8: Publish the Report to the Power BI Service
When the report is ready, publish it to the Power BI Service.
- In Power BI Desktop, click Home > Publish.
- Sign in with your Microsoft account.
- Choose the appropriate workspace.
Your report will then be available in the Power BI Service, subject to the permissions and licensing available in your organisation.
Step 9: Create the Dashboard
Once the report is in the Power BI Service, you can create a dashboard from it.
- Open the published report in the Power BI Service.
- Hover over a visual you want to feature.
- Select the Pin option.
- Choose an existing dashboard or create a new one.
- Repeat the process for other important visuals.
You can also pin an entire report page as a live tile. This gives you a single-page dashboard containing the most useful information from your report.
Step 10: Explore Report Interactivity
For deeper analysis, users can open the underlying report and use interactive features such as:
- Cross-filtering and highlighting: selecting one visual affects other visuals on the page.
- Drill down: move from a high-level view into more detailed data.
- Tooltips: hover over a data point to display extra information.
- Slicers and filters: change the report view to answer different questions.
This is one of the main differences between a dashboard and a report: the dashboard provides the summary, while the report provides the deeper interactive analysis.
Step 11: Best Practices for Beginners
- Start small: begin with a few useful visuals rather than trying to show everything.
- Focus on key metrics: decide what the audience actually needs to know.
- Use clean source data: good data preparation makes everything easier.
- Keep reports and dashboards consistent: use clear naming and formatting.
- Iterate: improve the report as users tell you what they need.
Step 12: Common Mistakes to Avoid
- Calling every Power BI page a dashboard: report pages are created in Desktop; dashboards are created in the Power BI Service.
- Cluttered pages: too many visuals make the analysis harder to understand.
- Inconsistent formatting: use consistent fonts, labels and number formats.
- Ignoring your audience: build around the questions users actually need answered.
- Forgetting to test: check calculations, filters and interactions before sharing.
Real-World Example
Imagine a retail business that wants to track performance. A simple Power BI report might include:
- A bar chart showing sales by region.
- A line chart showing sales over time.
- A map showing store performance.
- A card showing total revenue or profit margin.
- A slicer for product category or year.
After publishing the report, the business could pin the most important visuals to a one-page dashboard for senior managers, while keeping the full report available for deeper analysis.
Conclusion
Creating a Power BI dashboard is a two-stage process: first build a clear, useful report in Power BI Desktop, then publish it to the Power BI Service and pin the most important visuals to a dashboard.
Once you are comfortable with the basics, you can progress into more advanced data preparation, data modelling, DAX calculations and report design.
If you would like structured training with expert guidance, ExperTrain offers:
- Power BI Desktop Introduction – Learn the fundamentals of Power BI Desktop, connect to Excel data and create interactive report visuals, filters and slicers.
- Power BI Desktop Intermediate – Develop stronger Power Query, data modelling, DAX, themes, bookmarks and report design skills.
- Power BI Desktop Advanced – Progress into advanced DAX, Power Query transformations and more sophisticated visualisation techniques.
You can also compare the complete Power BI training pathway to find the most appropriate level.
Want to build Power BI reports with confidence? Start with our Power BI Desktop Introduction course, or compare the full Power BI training pathway.
Need a quick explanation of a Power BI term, feature or concept?
Browse our free Power BI GlossaryFound this guide useful? Add ExperTrain as a Preferred Source on Google to help surface more of our training guides, articles and learning resources.
.png){kind=small}
