Sales Dashboard in Power BI

Build an interactive sales dashboard with charts, slicers, and DAX measures.

Introduction

30 Second Summary

Every business generates data, but raw numbers in a spreadsheet don't tell you much. The real value comes when you can spot trends, compare regions, and filter results on the fly.

In this project, you will build an interactive sales performance dashboard in Power BI Desktop. You'll import financial data, transform it, and create visuals that let you explore sales across countries, time periods, and market segments.

What You'll Build

A multi-visual sales dashboard in Power BI Desktop that analyzes financial data across countries, market segments, and time periods using bar charts, line charts, and interactive slicers.

By the end of this project, you'll have:

A working Power BI Desktop report with bar charts, a line chart, and slicers that filter your data interactively.
Hands-on experience with the full Power BI workflow: importing data, transforming it with Power Query, and building visualizations.
A saved .pbix report file you can reopen, share, or publish to the Power BI service.
Secret Mission: Add a calculated DAX measure for profit margin and display it as a KPI card visual.

Are there any prerequisites?

No prior Power BI or data analysis experience is needed. You do need a Windows PC (Windows 10 or later) because Power BI Desktop is a Windows-only application.

Install Power BI Desktop

Power BI Desktop is the free Windows application you will use to build your sales dashboard. It connects to data sources, transforms data, and creates interactive visual reports.

In this step, you will install Power BI Desktop from the Microsoft Store and take a quick tour of the interface.

In this step, get ready to:

Install Power BI Desktop from the Microsoft Store.
Launch the app and close the welcome dialog.
Identify the main workspace areas: Report canvas, Visualizations pane, Fields pane, and ribbon.

Install from the Microsoft Store

The Microsoft Store version is recommended because it updates automatically each month. You do not need admin rights to install it this way.

Press the Windows key on your keyboard to open your Start menu.
Type Microsoft Store and press Enter to open it.
In the Microsoft Store search bar at the top, type Power BI Desktop and press Enter.
Select Power BI Desktop from the search results (published by Microsoft Corporation).
Click Install (or Get) and wait for the download to complete.

✔️ I already have Power BI Desktop installed

If you already have Power BI Desktop on your machine, you can skip ahead to the next substep where you launch the app.

ⓧ The install seems stuck or failed

If the install is not completing, try the following:

Make sure you are connected to the internet.
Check that your Windows version is Windows 10 or later.
Close and reopen the Microsoft Store, then try the install again.

If issues persist, you can download Power BI Desktop directly from the Microsoft Download Center as an alternative.

Why install from the Microsoft Store?

The Microsoft Store version automatically installs updates every month. This keeps you on the latest version without any manual effort.

The alternative is downloading an executable from the Microsoft Download Center. That approach requires admin rights and manual updates.

Launch Power BI Desktop

Press the Windows key to open your Start menu.
Type Power BI Desktop and press Enter to open the app.
A welcome screen appears with options to connect to data or open recent files.
Close the welcome dialog by clicking the X in the top-right corner of the dialog (not the main window).

You should now see a blank Report canvas in the center of the screen.

Seeing a gray screen or error on launch?

Power BI Desktop requires the Microsoft Edge WebView2 Runtime. If you see a gray window or a WebView2 error, try restarting your computer first.

If the issue persists, antivirus software may be interfering. Temporarily disable it and try launching again.

Help me troubleshoot why Power BI Desktop won't launch on my Windows PC.

Explore the interface

Before building anything, take a moment to identify the main areas of the workspace.

Look at the center of the screen. This is the Report canvas where you will build your visuals.
On the right side, find the Visualizations pane. This is where you choose and customize chart types.
Below or beside the Visualizations pane, find the Fields pane. This shows your data tables and their columns once you load data.
At the top, find the ribbon with tabs including Home, Insert, and Modeling.

What are these panes for?

The Report canvas is your workspace for placing charts, tables, and other visuals. Think of it like a slide in a presentation.

The Visualizations pane lets you pick the chart type (bar, line, pie, etc.) and configure how data maps to it. The Fields pane is your data inventory. You drag fields from here into your visuals.

Notice the view icons on the left

On the left sidebar, you will see small icons for Report view, Data view, and Model view. You are currently in Report view (the chart icon). You will use Data view later to inspect your loaded data.

Your workspace is ready. Next up, you will import real financial data and see it appear in the Fields pane.

Import the Financial Sample Data

Power BI Desktop is installed and ready to go. Now it's time to load some data so you have something to visualize.

Every dashboard starts with a dataset. Power BI Desktop includes built-in sample data you can load directly, without downloading any external files. In this step, you'll load Microsoft's Financial Sample and confirm it appears in your report.

In this step, get ready to:

Load the built-in Financial Sample dataset into your report.
Verify the data appears in the Fields pane.
Inspect the raw data in Table view.

Load the built-in sample data

Power BI Desktop ships with sample datasets you can load without leaving the application. The Financial Sample contains sales and profit data sorted by market segment and country, which is perfect for building a multi-visual dashboard.

On the Report canvas, look for the Add data to your report section in the center of the screen.
Select Use sample data.
In the Two ways to use sample data dialog that appears, choose Load sample data.
In the Navigator window, select Financials in the left pane.
Click Load.

What does this do?

The Navigator shows you a preview of the data before committing to import it. Selecting Load brings the full Financials table into your report's data model, making it available for building visualizations.

Power BI takes a moment to import the data. Once it finishes, the blank canvas returns and you're ready to verify the import.

Verify your data loaded

After loading data, the Fields pane on the right side of the screen should now show your imported table and its columns.

Look at the Fields pane on the far right of the screen.
Confirm you see a Financials table listed.
Click the small arrow next to Financials to expand the table and see its fields.

You should see fields including Country, Segment, Product, Units Sold, Sale Price, Gross Sales, Discounts, Sales, COGS, and Profit.

Don't see the Financials table?

If the Fields pane is empty, the data may not have loaded. Go to Home on the ribbon and try selecting Get data to start the import process again from scratch.

If the Fields pane is not visible at all, make sure you are in Report view by clicking the top icon on the left sidebar.

help me find and load the Financial Sample data in Power BI Desktop

Switch to Table view to inspect your data

Report view shows visuals, but sometimes you need to see the actual rows and columns of your data. Table view lets you inspect the raw data that powers your report.

On the left sidebar, click the Table view icon (it looks like a small table grid). It is the second icon from the top.
You should see rows of financial transactions with columns for each field (Country, Segment, Product, Sales, Profit, and more).
Scroll through a few rows to get a feel for the data you'll be visualizing.
When you're done, click the Report view icon (the top icon on the left sidebar, which looks like a chart) to return to the canvas.

What is Table view?

Table view shows your data after it has been loaded into the model. It's useful for verifying that columns have the right data types and that your values look correct before building visuals.

You can switch between Report, Table, and Model views at any time using the icons along the left side of Power BI Desktop.

Your data is loaded and verified. Next up, you'll use Power Query to check and clean the data types before building your first visuals.

Transform Data with Power Query

Your data is loaded, but raw data often has issues hiding beneath the surface. Columns that look numeric might actually be stored as text, which breaks calculations and chart aggregations.

Power BI includes a built-in tool called Power Query that lets you clean and reshape data before you start building visuals. In this step, you'll open the Power Query Editor, verify your column data types, and apply the changes.

In this step, get ready to:

Open the Power Query Editor from the Home ribbon.
Check and fix column data types so numeric fields are recognized as numbers.
Close and apply your transformations to return to Report view.

Open Power Query Editor

The Power Query Editor is a separate window inside Power BI Desktop where all data cleaning happens. Any changes you make here are saved as repeatable steps that run every time your data refreshes.

Make sure you are in Report view (the chart icon on the left sidebar).
On the Home ribbon at the top, click Transform data.

A new window opens. This is the Power Query Editor, with its own ribbon, a list of queries on the left, and a data preview in the center.

What is Power Query?

Power Query is Power BI's data transformation engine. It records every change you make as a named step (visible in the Applied Steps pane on the right).

When your data source updates in the future, Power BI replays those same steps automatically. You clean once, and it stays clean.

Don't see Transform data on the ribbon?

Make sure you are on the Home tab of the ribbon, not the Insert or Modeling tab.

If your ribbon is collapsed, double-click the Home tab name to expand it.

help me find the Transform data button in Power BI Desktop

Check and fix data types

Each column header in the Power Query Editor shows a small icon indicating its data type. Text columns show ABC, number columns show 123, and date columns show a calendar icon. If any numeric column (like Sales, Profit, or COGS) shows ABC instead of 123, it needs correcting.

In the Queries pane on the left side, confirm that Financials is selected.
Scan the column headers in the data preview. Verify that columns like Sales, Profit, COGS, Gross Sales, and Units Sold display a 123 icon (indicating a numeric type).
If any numeric column shows ABC (text) instead, select that column header by clicking on it.
On the Transform tab in the ribbon, click Detect Data Type in the Any column group to auto-correct the type.

Why do data types matter?

If a column like Sales is stored as text, Power BI cannot sum it, average it, or plot it on a chart axis. Fixing data types here ensures your visuals work correctly in the next steps.

Many Power BI features (filters, aggregations, date hierarchies) are only available when columns have the correct type assigned.

Select multiple columns at once

Hold Ctrl (Windows) and click each column header you want to fix. Then click Detect Data Type once to correct them all together.

Close and apply your changes

Once your data types look correct (all numeric columns show 123, text columns show ABC, and the Date column shows a calendar icon), you are ready to apply your changes.

On the Home ribbon of the Power Query Editor, click Close & Apply.

The Power Query Editor window closes and you return to Report view. Your transformations are now saved and the Financials table is clean.

What does Close & Apply do?

This button saves all the steps you created in Power Query and pushes the cleaned data into Power BI's data model. Every transformation is recorded, so if you ever refresh the data source, Power BI replays your steps automatically.

Seeing an error when applying?

If you see a type conversion error, it usually means a column contains values that do not match the detected type. Go back into the Power Query Editor (Home > Transform data), select the problem column, and manually set the correct type by clicking the icon next to the column header.

help me fix a data type error in Power Query

Your data is clean and ready to go. Next up, you'll turn these numbers into visuals by building your first charts.

Build Your First Visuals

Your data is cleaned and ready to go. Now comes the exciting part: turning rows of numbers into visual stories.

In this step, you will create three different chart types that each highlight a different angle of your sales data. Each visual answers a different business question.

In this step, get ready to:

Create a clustered bar chart showing sales by country.
Create a line chart tracking monthly sales trends over time.
Create a stacked bar chart comparing profit across market segments.

Create a clustered bar chart for sales by country

The first question your dashboard will answer is: which countries generate the most sales? A bar chart is the clearest way to compare totals across categories.

In Report view, click on the blank canvas area to make sure nothing is selected.
In the Visualizations pane on the right, select the Clustered bar chart icon (horizontal bars).
In the Fields pane (far right), expand the Financials table.
Drag Country to the Y-axis well in the Visualizations pane.
Drag Sales to the X-axis well.

You should now see a horizontal bar chart on the canvas with countries listed on the left and bars extending to the right based on total sales.

What does this visual show?

The clustered bar chart compares the sum of all sales for each country in the dataset. Power BI automatically aggregates (totals) the Sales column for each unique Country value.

This lets you instantly spot which countries are your strongest markets.

Don't see any bars?

Make sure you dragged Country to the Y-axis and Sales to the X-axis. If they are swapped, the chart may look empty or show a single bar.

Also confirm that the chart is selected (blue border around it) before dragging fields.

Help me troubleshoot my bar chart in Power BI.

Create a line chart for monthly sales trends

Next, you will track how sales change over time. A line chart is ideal for spotting seasonal patterns and growth trends.

Click on an empty area of the canvas to deselect the bar chart.
In the Visualizations pane, select the Line chart icon.
From the Fields pane, drag Date to the X-axis well.
Drag Sales to the Y-axis well.

Power BI automatically creates a date hierarchy when you use a date field. Your line chart initially shows data at the Year level.

What is a date hierarchy?

When you drag a date column into a visual, Power BI Desktop automatically creates a hierarchy with four levels: Year, Quarter, Month, and Day. This lets you drill into your data at different time granularities without creating extra columns.

To drill down to month level, look for the drill icons that appear at the top corner of the line chart visual.
Click the double downward arrow icon (Go to the next level in the hierarchy). This expands all data points to the next level.
Click the double downward arrow icon again to reach the Month level.

You should now see a line chart with months along the bottom and sales values on the left, showing how sales rise and fall over time.

Drill up if you go too far

If you drill down past Month to Day level, click the single upward arrow icon at the top of the visual to move back up one level in the hierarchy.

Line chart showing a single data point?

This usually means you are still at the Year level of the date hierarchy. Click the double downward arrow icon at the top corner of the visual to drill down to Quarter, then click it once more to reach Month.

Help me drill down in my Power BI line chart.

Create a stacked bar chart for profit by segment

Your final visual answers: which market segments are the most profitable? A stacked bar chart shows how profit distributes across segments like Government, Enterprise, and Midmarket.

Click an empty area of the canvas to deselect the line chart.
In the Visualizations pane, select the Stacked bar chart icon.
Drag Segment to the Y-axis well.
Drag Profit to the X-axis well.

You should see a horizontal bar chart with segments like Government, Midmarket, Enterprise, Small Business, and Channel Partners listed on the left.

Why a stacked bar chart here?

A stacked bar chart works well for comparing totals across categories. In this case, each bar represents one segment's total profit. You can quickly see which segments contribute the most to the bottom line.

Seeing negative values on some bars?

Some segments may show negative profit for certain time periods. This is normal in the Financial Sample dataset. It means those segments had higher costs than revenue in some transactions.

Help me understand negative profit values in my chart.

You now have three visuals on your canvas, each answering a different business question. Next up, you will add slicers that let you filter all of these visuals at once with a single click.

Add Slicers and Interactivity

Your dashboard already tells a story with three charts. But right now, you can only see all the data at once.

What if you wanted to focus on just one year, or a single market segment? That's where slicers come in. Slicers are interactive filters that sit on your report canvas and let you narrow down what every chart shows with a single click.

In this step, get ready to:

Add a Year slicer that filters all visuals by year.
Add a Segment slicer that filters by market segment.
Test cross-filtering between your charts.

Add a Year slicer

A Year slicer lets your audience pick a specific year and instantly see how every chart updates to reflect only that year's data.

Click on an empty area of the report canvas to make sure no existing visual is selected.
In the Visualizations pane on the right, click the Slicer icon (it looks like a filter funnel with a dropdown).
In the Fields pane (far right), expand the Date field by clicking the arrow next to it. You should see a Date Hierarchy with levels: Year, Quarter, Month, and Day.
Drag Date to the Field well in the Visualizations pane.
The slicer may display the full date hierarchy by default. Click the dropdown arrow on the slicer visual header and select Year from the hierarchy level options to show only years.

What is a slicer?

A slicer is a standalone filter control that lives directly on your report canvas. When you click a value in the slicer, it filters every other visual on the page to match your selection.

Unlike the Filters pane (which is hidden away), slicers are visible and clickable. They make your reports interactive for anyone viewing them.

Test your Year slicer by clicking one of the year values (e.g. 2013 or 2014).
Your bar chart, line chart, and stacked bar chart should all update to show data for only that year.
Click the same year value again to deselect it and restore the full dataset.

Slicer showing a date range slider instead of year buttons?

If your slicer shows a slider or date range instead of individual year values, it means the Date field was added as a raw date column rather than using the Date Hierarchy. Remove the field from the slicer, then drag the Date hierarchy field again and select the Year level from the dropdown on the slicer header.

Help me fix my Year slicer so it shows individual years instead of a slider.

Add a Segment slicer

The Financial Sample data includes a Segment field with values like Government, Midmarket, and Enterprise. Adding a Segment slicer lets you focus on a single market segment across all charts.

Click on an empty area of the canvas to deselect the Year slicer.
In the Visualizations pane, click the Slicer icon again to create a new slicer.
In the Fields pane, drag Segment to the Field well in the Visualizations pane.
A list slicer appears showing all segment values (Channel Partners, Enterprise, Government, Midmarket, Small Business).

Test your Segment slicer by clicking Government.
All three charts should update to show only Government segment data.
Click Government again to deselect and restore the full view.

Why use slicers instead of the Filters pane?

The Filters pane works behind the scenes and is often collapsed. Slicers are visible controls on the canvas that anyone can use without knowing where to look for hidden filters.

This makes your reports self-service. A manager can click a year or segment and explore the data without asking you to rebuild the view.

Don't see the Segment slicer values?

Make sure you dragged the Segment field (not another field) into the Field well. Check the Fields pane on the right for the Financials table and look for Segment in the list.

Help me troubleshoot my Segment slicer in Power BI.

Test cross-filtering between visuals

Slicers are not the only way to filter your dashboard. Power BI has a built-in feature called cross-filtering that makes every visual interactive.

Make sure no slicer values are currently selected (click any active selections to deselect them first).
Click on any single bar in your Sales by Country chart (for example, click the bar for France).
Look at your other visuals. The line chart and stacked bar chart should highlight or filter to show only data for that country.
Click the same bar again to deselect and return to the full view.

How does cross-filtering work?

When you click a data point in one visual, Power BI automatically filters or highlights the related data in every other visual on the page. This is built-in behavior that requires no configuration.

Cross-filtering is what makes Power BI dashboards feel truly interactive. Your audience can explore connections in the data just by clicking around.

Your dashboard now has five visuals: three charts and two slicers. Anyone viewing this report can filter by year, by segment, or by clicking directly on chart elements. Next up, you'll polish the layout and save your finished report.

Format and Polish Your Dashboard

Your visuals are built and interactive. Clicking a country bar cross-filters the whole page, and your slicers let viewers drill into specific years or segments.

The dashboard still looks unfinished, though. Visuals are scattered across the canvas without a clear reading order. In this step, you'll add a title, arrange everything into a clean grid, and save the final report.

In this step, get ready to:

Add a title text box to the top of your report.
Resize and arrange all visuals into a clean grid layout.
Save your finished report as a .pbix file.

Add a title to your report

A clear title tells viewers exactly what they're looking at. Without one, your dashboard is just a collection of charts with no context.

Click the Insert tab on the ribbon at the top of the window.
Select Text box.
A text box appears on your canvas. Type Sales Performance Dashboard inside it.
Highlight all the text you just typed.
Increase the font size using the size dropdown in the text formatting toolbar (try 24 or larger).
Click the Bold button (B) in the formatting toolbar.
Click the Center align button in the formatting toolbar.
Drag the text box to the top of your report canvas. Stretch it across the full width so the title sits centered above your visuals.

You should now see a large, bold title reading "Sales Performance Dashboard" spanning the top of your canvas.

Text box not showing up?

Make sure you clicked on the Insert ribbon tab first, not the Home tab. The Text box button only appears on the Insert ribbon.

If the text box landed behind a chart, right-click the text box and select Bring to front.

Help me position and format my title text box in Power BI.

Resize and arrange your visuals

A good dashboard layout guides the viewer's eye from the most important information to supporting detail. Slicers go near the top or side so viewers filter first, then read the charts.

Click on your Year slicer to select it. Drag it to the top-left area just below the title.
Click on your Segment slicer and position it next to the Year slicer (or directly below it).
Click on your Sales by Country bar chart. Drag its corner handles to resize it, then position it in the main area below the slicers.
Resize and position your Monthly Sales Trend line chart next to or below the bar chart.
Resize and position your Profit by Segment stacked bar chart to fill the remaining space.

Alignment guides

As you drag visuals around the canvas, Power BI shows red alignment guides when edges line up with other visuals. Use these to create even spacing between charts.

Your canvas should now look like a structured grid. The title spans the top, slicers are accessible near the top or left, and charts fill the remaining space in a balanced layout.

Visuals overlapping or too small?

If charts overlap, click one to select it, then use the corner handles to shrink it slightly. You can also use the arrow keys on your keyboard for fine-tuned positioning after clicking a visual.

If a visual gets too small and hides its labels, drag a corner outward to expand it until all text is readable.

Help me arrange my Power BI visuals into a clean dashboard layout.

Save your report

Power BI Desktop saves reports as .pbix files. This single file contains your data, transformations, and all visuals. You can reopen it anytime to continue working.

Click File in the top-left corner of the window.
Select Save As.
Choose a location on your computer (such as your Desktop or Documents folder).
Name the file Sales Performance Dashboard and click Save.

The title bar at the top of Power BI Desktop now shows your file name. Your report is saved.

What is a .pbix file?

A .pbix file is Power BI Desktop's native format. It bundles your data model, Power Query transformations, and report visuals into a single portable file. You can share it with anyone who has Power BI Desktop installed, or publish it to the Power BI service later.

Save option greyed out?

If Save As appears greyed out, make sure you are clicking File from the main ribbon (not from inside Power Query Editor). Close Power Query Editor first if it's still open.

Help me save my Power BI report.

Secret mission

Add a DAX Measure and KPI Card

Your dashboard looks great, but executives love seeing key metrics at a glance. In this secret mission, you'll write your first DAX formula to calculate profit margin, then display it as a KPI card that updates dynamically with your slicers.

Clean Up Your Resources

Decide whether to keep your resources running, pause them to come back later, or delete them entirely. This project runs entirely locally on your Windows PC, so there are no ongoing costs.

Resources you used:

Power BI Desktop (installed application from Microsoft Store).
Sales Performance Dashboard.pbix (saved report file on your computer).

Keep everything running

No action needed. Choose this if you're still actively building or plan to extend your dashboard further.

Your Sales Performance Dashboard.pbix file stays where you saved it. You can reopen it anytime in Power BI Desktop.
Power BI Desktop remains installed and will update automatically through the Microsoft Store.

Pause - I'll come back to this later

Close Power BI Desktop to free up memory. Your saved file will be waiting for you when you return.

Make sure your report is saved (File > Save).
Close Power BI Desktop.
To resume later, double-click your Sales Performance Dashboard.pbix file or open it from within Power BI Desktop.

Delete - I don't want to use this again

Remove all project resources from your computer entirely.

Delete your report file: navigate to the folder where you saved Sales Performance Dashboard.pbix, right-click the file, and select Delete.
Uninstall Power BI Desktop: press the Windows key, type Add or remove programs, and press Enter.
Search for Power BI Desktop in the app list, click the three-dot menu next to it, and select Uninstall.
Confirm the uninstall when prompted.

Nice Work!

You just built your first interactive sales dashboard in Power BI Desktop from scratch. You took raw financial data, shaped it, and turned it into a polished report that filters and responds to clicks in real time.

You've learned how to:

Imported financial data and used Power Query to verify and fix data types before building visuals.
Built multiple interactive visuals (clustered bar charts, line charts, and slicers) that cross-filter each other automatically.
Designed and saved a polished .pbix report with a clean layout, title, and consistent formatting.
Secret Mission: Created DAX measures for Profit Margin and Discount %, then displayed them as KPI cards that respond to slicer filters.

Ready to quiz yourself?