What a Power BI dashboard does and why you might want one
A Power BI dashboard is a single page that shows you charts, tables, and numbers pulled from your data files — all in one place so you can see patterns without opening multiple spreadsheets. If you have organized files the way the previous guide described, a dashboard lets you turn that organized data into something you can actually read at a glance.
Power BI is Microsoft's tool for this work. It connects to Excel files, databases, cloud storage, and other sources, then displays what you tell it to display. You do not need to be a programmer. The interface is visual — you drag fields into boxes, pick colors, and see the result when ready.
A dashboard is useful if you track something regularly: household spending, work hours, inventory, sales, or anything else where you want to spot trends without doing math by hand each time. If you have a single spreadsheet you check once a year, a dashboard is probably overkill. If you check data weekly or more often, it saves time.
Key Takeaways
- Power BI Desktop is the free tool where you build dashboards on your computer; Power BI Service is the paid online version where you share them with others.
- You start by connecting Power BI to your data source — usually an Excel file or a folder of files — then selecting which columns you want to display.
- A dashboard is built from visualizations: charts, tables, cards showing single numbers, and filters that let you narrow what you see.
- The most common mistake is trying to show too much on one page; a dashboard that shows everything is harder to read than the spreadsheet you started with.
Downloading and opening Power BI Desktop
Power BI Desktop is free and runs on Windows. Go to microsoft.com/power-bi/desktop, click the read button, and run the installer. It will take a few minutes. Once it opens, you will see a blank canvas on the right side and a list of options on the left.
If you use a Mac, Power BI Desktop is not available. You can use Power BI Service (the online version) through a web browser, but that requires a paid subscription. Alternatively, some people use Google Data Studio or Tableau Public, which are free and work on any computer — but this guide covers Power BI specifically.
When you first open Power BI Desktop, you will see buttons for "Get data", "Recent sources", and "Open other reports". Click "Get data" to start connecting to your files.
Connecting to your data files
Click "Get data" and you will see a list of sources: Excel, SQL Server, SharePoint, Google Sheets, and many others. If your data is in an Excel file on your computer, click "Excel" and navigate to the file. If your data is in a folder with multiple files, click "Folder" and point Power BI to that folder — it will combine all compatible files in that location.
Once you select a file or folder, Power BI shows you a preview of the data. You will see table names on the left. Click the checkbox next to each table you want to use, then click "Load". Power BI will import that data into the dashboard project.
If your data changes in the original file, you can refresh the dashboard to pull the new numbers. In Power BI Desktop, click the refresh icon in the toolbar. If you later move the file to a different folder or rename it, Power BI will ask you to reconnect when you open the dashboard again.
Building your first visualization
After loading data, you will see the data fields listed on the right side under "Fields". On the left, you will see visualization options: a table icon, a bar chart icon, a line chart icon, and others. Click the visualization type you want — start with a straightforward bar chart or table.
Once you pick a visualization type, a blank chart appears in the center. Now drag fields from the right side into the boxes labeled "Axis", "Legend", "Values", or "Details" depending on the chart type. For example, if you want to see total spending by category, drag "Category" into the Axis box and "Amount" into the Values box. Power BI will draw the chart when ready.
Resize the chart by dragging its corners. Move it by dragging its title. You can create as many visualizations as you want on a single page — they all sit on the same dashboard canvas.
Adding filters and arranging your layout
Filters let you narrow what a chart shows without changing the underlying data. Drag a field into the "Filters" box at the top of the visualization panel, and Power BI will add a filter control to the dashboard. Click the filter to show only certain values — for example, only spending from the last three months, or only a specific category.
You can also add a filter that affects the entire dashboard, not just one chart. In the Filters panel on the right, drag a field into the "Page level filters" section. Now when you change that filter, every chart on the page updates.
Arrange your visualizations so the most important ones are at the top left, where people look first. Power BI does not force a grid — you can place charts anywhere. Overlapping charts is usually a mistake; use the alignment tools in the toolbar to space them evenly if you have many.
Choosing colors and labels that make sense
By default, Power BI uses blue for everything. You can change colors by right-clicking a chart and selecting "Format visual", then clicking the paint bucket icon. Pick a color scheme that matches your organization or personal preference — just avoid combinations that are hard to read on screen.
Add a title to each chart so someone looking at the dashboard knows what they are seeing. Click the chart, then in the Format panel on the right, find "Title" and turn it on. Edit the text to be specific: "Monthly spending by category" is clearer than "Spending".
If a chart shows currency, percentages, or dates, format those values so they display correctly. Right-click the chart, select "Format visual", and look for "Data labels" or "Value formatting". For money, choose currency and set decimal places. For percentages, choose percentage format.
Common mistakes and how to avoid them
The most common mistake is putting too much on one dashboard. If you have ten charts, the page becomes cluttered and hard to read. Instead, create multiple dashboards — one for spending, one for time tracking, one for inventory — and switch between them. Each dashboard should answer one main question.
Another mistake is forgetting to refresh your data. If you update the original Excel file, the dashboard does not automatically change. You have to click the refresh button in Power BI. If you share the dashboard with others, they will see stale numbers unless you set up automatic refresh — which requires Power BI Service, the paid version.
A third mistake is using the wrong chart type. A pie chart with more than five slices becomes unreadable. A line chart works for trends over time, but not for comparing categories. A table works when you need exact numbers, but a bar chart is faster to read when you just want to see which is biggest.
Saving and sharing your dashboard
In Power BI Desktop, click File and then Save. Give your dashboard a name and choose where to store it. Power BI saves as a .pbix file — this is the complete dashboard including all the data, formatting, and connections.
To share a dashboard with someone else on your computer, send them the .pbix file. They can open it in Power BI Desktop and see everything you built. If they update the original data files, they can refresh the dashboard to see new numbers.
If you want to share with people who do not have Power BI Desktop, you have two options. You can export a single visualization as an image or PDF by right-clicking it and selecting "Export". Or you can publish to Power BI Service, which is the online version — but that requires a paid subscription and a Microsoft account.
Frequently Asked Questions
Do I need to know how to code to use Power BI?
No. Power BI Desktop is designed for people who know spreadsheets but not programming. You drag fields, click buttons, and see results. If you want to do advanced things like write formulas or connect to databases, you will need to learn more — but basic dashboards require no coding.
Can I update my dashboard automatically when my data changes?
In Power BI Desktop, you have to click refresh manually each time. If you want automatic updates, you need Power BI Service, the paid online version, which can refresh on a schedule you set. For most people tracking personal data, manual refresh is fine.
What if my data is in Google Sheets instead of Excel?
Power BI can connect to Google Sheets. Click "Get data", search for "Google Sheets", and sign in with your Google account. Power BI will show you a list of your sheets and let you pick which ones to load. The process is the same as with Excel files.
Can I make a dashboard that other people can edit?
In Power BI Desktop, only the person with the .pbix file can edit it. If you want multiple people to edit the same dashboard, you need Power BI Service and a shared workspace, which requires paid licenses. For most household or small team use, one person builds the dashboard and shares a read-only version with others.
What is the difference between Power BI Desktop and Power BI Service?
Power BI Desktop is free software you install on your computer. Power BI Service is the online version that requires a paid subscription. Desktop is where you build dashboards. Service is where you publish them so others can see them in a web browser without installing anything.