Build a Sales Dashboard in Power BI
Build an interactive sales dashboard with KPI cards, charts, and slicers.
Introduction
30 Second Summary
Every team collects sales data, but most of it sits in spreadsheets where patterns hide and sharing insights means sending static screenshots. A well-built dashboard turns that raw data into something anyone can read at a glance and explore on their own.
In this project, you will build an interactive sales dashboard in Power BI Desktop using a built-in sample dataset. You'll clean the data, write DAX measures, create KPI cards and charts, and add slicers that let viewers filter everything with a single click.
What You'll Build
You open your finished dashboard and immediately see four headline KPIs at the top. Below, a monthly trend line reveals seasonal patterns while bar charts rank performance by country and product. Click a slicer and the entire page updates instantly.
By the end of this project, you'll have:
- A live dashboard where clicking a single slicer updates every KPI card, trend line, and chart on the page.
- Four DAX measures you wrote from scratch that calculate Total Sales, Total Profit, Profit Margin %, and Units Sold and respond correctly to any filter combination.
- A polished, portfolio-ready .pbix file you can screenshot for your resume or upload to GitHub to prove you can do the reporting work companies actually hire for.
- Secret Mission: a Top 5 Products by Profit table with conditional data bars that highlight which products drive the most money.
Are there any prerequisites?
You need Power BI Desktop installed on a Windows machine. Power BI Desktop is a free download from the Microsoft Store or Microsoft Download Center. No prior Power BI experience is required.
Before We Start
Before We Start...
Before we dive in, let's lock in what you're about to build and why it matters.
Load the Financial Sample Data
Every dashboard starts with data. Power BI Desktop ships with a built-in Financial Sample dataset, so you can start building immediately without downloading anything.
In this step, you'll load that sample dataset and confirm the columns are ready for your KPI calculations and charts.
In this step, get ready to:
- Load the built-in Financial Sample dataset.
- Confirm the financials table appears in the Fields pane with all expected columns.
Load the Financial Sample dataset
Power BI Desktop's welcome screen gives you direct access to sample data. This saves you from finding and importing a CSV file yourself.
- On the welcome screen in Power BI Desktop, click Use sample data.
- In the Two ways to use sample data dialog that appears, choose Load sample data.
- In the Navigator window, check the box next to financials in the left pane.
- Click Load.
After a moment, the Navigator closes and you return to the report canvas. The data is now loaded into your file.
What if I don't see the welcome screen?
If you've already dismissed the welcome screen and see a blank canvas, go to the Home ribbon at the top. Click Get Data and then choose the sample data option to reach the same dialog.
Don't see the Use sample data option?
Make sure you're on the very first welcome screen that appears when Power BI Desktop opens with no file loaded. If you accidentally opened an existing file, close it by going to File then Close. The welcome screen should reappear.
help me find the sample data option in Power BI Desktop
Confirm the data loaded correctly
Before you predict what you'll see, think about what a loaded dataset should look like in Power BI. Where would columns and tables appear?
- Look at the Fields pane on the right side of your screen.
- Click the arrow next to the financials table to expand it.
You should see columns including: Segment, Country, Product, Discount Band, Units Sold, Manufacturing Price, Sale Price, Gross Sales, Discounts, Sales, COGS, Profit, Date, Month Number, Month Name, and Year.
✔️ I see the financials table with all columns
Your data is loaded and ready to go. You now have a full dataset with sales transactions spanning multiple segments, countries, and products.
ⓧ I don't see the Fields pane or the financials table
If the Fields pane is not visible, go to the View ribbon at the top and make sure the Fields checkbox is ticked.
If the pane is visible but empty, the data did not load. Go back to the Home ribbon, click Get Data, and try loading the Financial Sample again.
What is the Financial Sample dataset?
This is a flat single-table dataset built into Power BI Desktop. It contains sales transaction rows spanning 2013 to 2014, covering 5 market segments, 5 countries, and 6 products.
It has enough variety to build a realistic portfolio dashboard with trends, breakdowns, and filtering. You'll use these columns to create KPI measures and interactive charts in the next steps.
Your data is loaded and ready to work with. Next up, you'll clean this dataset in Power Query to remove unnecessary columns and verify data types before building any visuals.
Clean the Data in Power Query
Your data is loaded, but raw data always has issues that produce wrong results if you don't fix them first.
The Financial Sample has a column you won't need and data types that may not be set correctly. Cleaning before you build charts means your measures and visuals will be accurate from the start.
In this step, get ready to:
- Remove the Discount Band column you won't use.
- Verify that all columns have the correct data types.
- Remove blank rows and apply your changes.
Open Power Query and remove the Discount Band column
Power Query is Power BI's built-in data transformation tool. It lets you clean and reshape data before it reaches your dashboard.
- In Power BI Desktop, click the Home ribbon tab.
- Click Transform Data to open the Power Query Editor.
The Power Query Editor opens in a new window showing your financials table in the center pane. You can see all 16 columns of your data.
- Find the Discount Band column header in the data preview.
- Right-click the Discount Band column header.
- Select Remove from the context menu.
The Discount Band column disappears from the data preview immediately. You can see a new step called "Removed Columns" appear in the Applied Steps pane on the right.
What is Power Query doing behind the scenes?
Every action you take in Power Query is recorded as a step. These steps run in order every time the data refreshes, so your cleaning is always applied automatically.
The underlying data source is never changed. Power Query only shapes its view of the data before loading it into your report.
Verify data types and remove blank rows
Each column header in Power Query shows a small icon on its left side that indicates the data type. Getting types right now prevents calculation errors in your DAX measures later.
- Look at the icon to the left of the Date column header. Confirm it shows a calendar icon, which means the Date type is set correctly.
- Check the numeric columns: Units Sold, Sales, Profit, COGS, Gross Sales, Discounts, Manufacturing Price, and Sale Price. Each should show a "1.2" icon indicating the Decimal Number type.
- If any numeric column shows "ABC" (Text type) instead, click the icon to the left of that column header and select Decimal Number from the dropdown.
What do the data type icons mean?
A calendar icon means Date. The "1.2" icon means Decimal Number. "ABC" means Text. "123" means Whole Number.
You can change a column's type by clicking the icon on the left side of the column heading and selecting the correct type from the list that appears.
Now remove any rows that are entirely blank so they don't skew your calculations.
- Click the Home tab in the Power Query Editor ribbon.
- In the Reduce Rows group, click the Remove Rows dropdown.
- Select Remove Blank Rows from the dropdown menu.
A new step appears in the Applied Steps pane confirming the blank rows have been removed.
Don't see the Reduce Rows group?
Make sure you are on the Home tab of the Power Query Editor ribbon, not the main Power BI Desktop ribbon. The Power Query Editor has its own set of ribbon tabs.
help me find the Remove Blank Rows option in Power Query Editor
Apply your changes and return to the report canvas
Before you apply your changes, think about what you expect to see in the Fields pane when you return to the report canvas. Will you see all 16 original columns, or fewer?
- Click Close & Apply in the top-left corner of the Power Query Editor.
Power BI processes your changes and returns you to the report canvas. In the Fields pane on the right, expand the financials table.
You should see 15 columns listed. The Discount Band column is gone, and all remaining columns are ready with correct data types.
Still seeing Discount Band in the Fields pane?
Make sure you clicked Close & Apply (not just the X button to close the window). Closing without applying discards all your Power Query changes.
If you accidentally closed without applying, click Transform Data again on the Home ribbon and redo your steps.
help me apply my Power Query changes correctly
Your data is clean and ready to work with. Next up, you'll write DAX measures and build KPI cards that turn these raw numbers into headline metrics.
Create DAX Measures and KPI Cards
Your data is clean and loaded. Now you need a way to calculate the headline numbers that will sit at the top of your dashboard.
Dragging raw columns into a visual gives you a basic sum, but you have no control over how the number is calculated. DAX measures solve this by letting you define exactly how numbers are computed. They also respond correctly to filters, which becomes critical once you add slicers later.
In this step, get ready to:
- Write four DAX measures: Total Sales, Total Profit, Profit Margin %, and Units Sold.
- Create Card visuals for each measure and arrange them across the top of the canvas.
- Format the cards so the numbers are large and readable at a glance.
Write your first DAX measure
A DAX measure is a formula you write that tells Power BI exactly how to calculate a value. You will create your first measure now and see it appear in the Fields pane.
- In the Fields pane on the right, right-click the financials table.
- Select New measure from the menu that appears.
- A formula bar appears at the top of the canvas. Type the following formula and press Enter to confirm it:
Total Sales = SUM(financials[Sales])
What does this formula do?
The left side of the equals sign names the measure (Total Sales). The right side tells Power BI to add up every value in the Sales column of the financials table.
Unlike dragging the raw Sales column into a visual, this measure will recalculate automatically whenever someone applies a filter or slicer.
Look at the Fields pane. You should see Total Sales listed under the financials table with a small calculator icon next to it. That icon confirms it is a measure, not a column.
Create the remaining three measures
You will repeat the same process three more times. Each measure uses the same pattern: right-click the financials table, select New measure, type the formula, and press Enter.
- Create a new measure and type this formula for Total Profit:
Total Profit = SUM(financials[Profit])
- Create another new measure and type this formula for Profit Margin %:
Profit Margin % = DIVIDE([Total Profit], [Total Sales], 0)
- Create one final measure and type this formula for Units Sold:
Units Sold = SUM(financials[Units Sold])
Why does Profit Margin % use DIVIDE instead of a slash?
The DIVIDE function performs safe division. If the denominator is ever zero (for example, when a filter returns no sales data), it returns the third argument (0) instead of crashing with an error.
The square brackets around [Total Profit] and [Total Sales] reference the measures you just created. DAX lets measures build on other measures.
Check the Fields pane again. You should now see all four measures listed under financials, each with a calculator icon: Total Sales, Total Profit, Profit Margin %, and Units Sold.
Don't see all four measures?
If a measure is missing, you may have dismissed the formula bar before pressing Enter. Right-click the financials table again, select New measure, and retype the formula.
If you see a red underline in the formula bar, check for typos in the column names. They must match exactly: financials[Sales], financials[Profit], financials[Units Sold].
Help me fix a DAX measure that isn't appearing in my Fields pane.
Build KPI Card visuals
Measures only calculate when placed inside a visual. A KPI Card displays a single number prominently, making it perfect for headline metrics.
- Click an empty area on the report canvas to deselect everything.
- In the Visualizations pane on the right, click the Card visual icon (it looks like a single number tile).
- An empty card appears on the canvas. From the Fields pane, drag Total Sales into the card's Fields well in the Visualizations pane.
Before you look at the result, predict: what kind of number do you expect to see? A count, a dollar amount, or something else?
The card now displays a large number representing the total of all sales in the dataset. This is your first visible KPI.
- Resize the card by dragging its corner handles so it is compact and fits the top-left area of the canvas.
- Click an empty area of the canvas again to deselect.
- Create a new Card visual and drag Total Profit into it.
- Create another Card and drag Profit Margin % into it.
- Create a final Card and drag Units Sold into it.
- Arrange all four cards in a horizontal row across the top of the canvas by dragging and resizing them.
You should now see four cards showing real numbers from your dataset. Each card displays the aggregate value for its measure.
Card showing the word blank instead of a number?
This usually means you dragged a column name instead of a measure. Check that the field in the card's Fields well shows the calculator icon next to its name. If it shows a column icon instead, remove it and drag the correct measure from the Fields pane.
Help me fix a Card visual showing blank instead of my DAX measure value.
Format the cards for readability
The default font size for card values is often too small to read at a glance on a dashboard. You will increase the callout value size and format Profit Margin % to display as a percentage.
- Click the Total Sales card to select it.
- In the Visualizations pane, click the Format visual icon (paint roller).
- Expand the Callout value section.
- Set the font size to 28 (any value between 28 and 32 works well).
- Repeat this for the other three cards: select each card, open the Format pane, and set the callout value font size to the same value.
Now format Profit Margin % so it displays as a percentage instead of a decimal.
- In the Fields pane, click the Profit Margin % measure (single click to select it, not drag).
- A Measure tools ribbon tab appears at the top of the window. Click it.
- In the Format dropdown, select Percentage.
- Set decimal places to 1.
Look at your Profit Margin % card. It should now display a percentage value (like 14.2%) instead of a decimal (like 0.142).
Why use Measure tools instead of the card's Format pane?
Formatting via Measure tools sets the format at the measure level. This means any visual that uses Profit Margin % will automatically display it as a percentage.
If you only formatted it inside the card, you would need to re-apply that format every time you use the measure in a new chart or table.
Profit Margin % still showing a decimal?
Make sure you clicked the measure name in the Fields pane (not inside a card visual) so the Measure tools tab appears. If the tab does not appear, try clicking directly on the calculator icon next to the measure name.
Help me format my Profit Margin measure as a percentage in Power BI.
Your canvas should now show four Card visuals in a row at the top. Each displays a clear, readable number: Total Sales, Total Profit, a Profit Margin percentage, and Units Sold.
You now have four headline KPIs on your dashboard. Next, you will add charts that show where revenue comes from and how it changes over time.
Build Trend and Breakdown Charts
Your KPI cards are live and showing real numbers from the dataset. Now you need to answer the next question: where does that revenue come from, and how does it change over time?
Cards show a single snapshot. To make your dashboard useful for decision-making, you need charts that reveal trends and breakdowns. In this step, you'll build a line chart for monthly revenue and bar charts that rank performance by country and product.
In this step, get ready to:
- Create a monthly sales trend line chart.
- Build bar charts ranking sales by country and product.
- Identify a critical limitation in your dashboard.
Create the monthly sales trend line chart
A line chart is the best way to show how a value changes over time. You'll plot your Total Sales measure against the Date column to reveal seasonal patterns in revenue.
- Click an empty area on the canvas below your KPI cards.
- In the Visualizations pane on the right, click the Line chart icon (it looks like a zigzag line).
- From the Fields pane, drag Date to the X-axis well.
- Drag Total Sales (your measure) to the Y-axis well.
Power BI automatically creates a date hierarchy with Year, Quarter, Month, and Day levels. You only want Year and Month for a clean trend view.
- In the X-axis well, click the small dropdown arrow next to Date and remove the Day and Quarter levels so only Year and Month remain.
- Resize the chart to fill roughly half the width below your KPI cards.
- Double-click the chart title and change it to Monthly Sales Trend.
You should see a line chart showing monthly sales data across 2013 and 2014, with peaks and valleys revealing seasonal patterns in revenue.
What does this chart show?
The line chart plots your Total Sales measure over time. Each point on the line represents one month's total revenue across all segments, countries, and products combined.
Because you used a DAX measure instead of dragging the raw Sales column, this chart will respond correctly to filters later. That distinction matters once you add slicers.
Seeing a flat line or no data?
Make sure you dragged the Total Sales measure (not the raw Sales column) to the Y-axis. Measures appear with a calculator icon in the Fields pane.
If the chart shows only one data point, check that Date is on the X-axis (not in a filter well) and that you've drilled down to the Month level using the hierarchy arrows.
Why isn't my line chart showing monthly data points?
Build the Sales by Country bar chart
A clustered bar chart ranks categories from highest to lowest. This makes it easy to see which countries drive the most revenue at a glance.
- Click an empty area on the canvas (not on an existing visual).
- In the Visualizations pane, click the Clustered bar chart icon (horizontal bars).
- Drag Country to the Y-axis well.
- Drag Total Sales to the X-axis well.
- Resize the chart and position it to the right of your line chart.
- Double-click the chart title and change it to Sales by Country.
The countries are now ranked by revenue from highest to lowest. You can see at a glance which markets generate the most sales.
Build the Sales by Product bar chart
- Click empty space on the canvas again.
- Select the Clustered bar chart icon from the Visualizations pane.
- Drag Product to the Y-axis well.
- Drag Total Sales to the X-axis well.
- Position the chart below or alongside your other charts.
- Double-click the chart title and change it to Sales by Product.
Hover over any bar in either chart. A tooltip appears showing the exact sales value for that country or product.
Why clustered bar charts for rankings?
Horizontal bar charts are the standard choice for comparing categories. The bars automatically sort from longest to shortest, making it instantly clear which country or product leads.
This is a pattern you'll see in professional dashboards everywhere. Hiring managers expect it because it communicates rankings without requiring the viewer to read labels carefully.
Chart showing vertical bars instead of horizontal?
You may have selected Clustered column chart (vertical) instead of Clustered bar chart (horizontal). Click the chart, then in the Visualizations pane, switch to the Clustered bar chart icon. Your data stays in place.
Why is my bar chart showing vertical columns instead of horizontal bars?
Notice what's missing from the dashboard
Take a step back and look at your dashboard as a whole. It has KPI cards, a trend line, and ranking charts. It looks professional. But try to answer this question:
If a manager asked "How did we do in 2014?" or "What about just the Government segment?", could you answer using the dashboard right now?
You can't. The dashboard shows ALL the data at once. Every year, every segment, every country is combined into those totals. There's no control for a viewer to isolate a specific slice of the data.
The dashboard is informative but static. That's the gap you'll close in the next step.
Why does this matter?
A dashboard that only shows totals forces someone to rebuild charts every time they have a question. Interactive filtering is what separates a real reporting tool from a static screenshot.
Your charts are built and telling a clear story about where revenue comes from. Next up, you'll add slicers that let viewers filter the entire dashboard with a single click.
Add Slicers and Polish the Layout
Your dashboard now shows KPI cards, trend lines, and breakdown charts. That is a solid foundation. But remember the problem you noticed at the end of the last step: the dashboard shows ALL the data at once with no way to filter it.
In this step, you will add slicers that let viewers filter by year, segment, or country. Then you will polish the layout with a professional theme and clean alignment. This is what transforms a static report into a real decision-making tool.
In this step, get ready to:
- Add three slicers (Year, Segment, Country) so viewers can filter the entire dashboard.
- Test interactivity by clicking slicer options and watching all visuals update.
- Polish the layout with a color theme, aligned visuals, and a dashboard title.
Create the Year, Segment, and Country slicers
A slicer is a visual filter control that sits directly on the canvas. When a viewer clicks an option in a slicer, every other visual on the page updates to show only the filtered data.
- Click an empty area on the report canvas to deselect any existing visual.
- In the Visualizations pane on the right, click the Slicer icon (it looks like a funnel with a dropdown).
- From the Fields pane, drag Year into the slicer's Field well.
- Resize the slicer and position it in the top-right corner of your canvas or above your charts.
You should see the Year slicer appear on the canvas displaying the available years from the dataset (2013 and 2014).
- Click an empty area on the canvas again.
- Add another Slicer visual from the Visualizations pane.
- Drag Segment into the new slicer's Field well.
- Repeat once more: add a third Slicer visual and drag Country into its Field well.
- Arrange all three slicers neatly. Stack them vertically on the right side of the canvas, or place them in a row above your charts.
Your canvas now has three slicer controls. Each one shows the distinct values from its field (years, segments, countries).
What is a slicer?
A slicer is a standalone filter control that lives on the report page. Unlike the hidden Filters pane, slicers are visible to anyone viewing the report.
When you click an option in a slicer, Power BI sends that filter to every other visual on the page. This is called cross-filtering, and it is what makes dashboards interactive.
Slicer showing a single value instead of a list?
If your slicer displays a slider bar or a single dropdown instead of a list of options, click the slicer, then click the small down-arrow icon on the slicer header and change it to List mode.
If the slicer is blank, make sure you dragged the field into the Field well (not the tooltip or other wells).
Still stuck? Why isn't my slicer showing the correct options?
Test interactivity across all visuals
Remember the limitation you noticed in the last step: the dashboard showed all data at once with no way to answer questions like "How did we do in 2014?" Your slicers are now in place to fix that.
Before you click anything, think about this: if you click 2014 in the Year slicer, what do you expect to happen to the KPI cards and charts?
- Click 2014 in the Year slicer.
- Watch all four KPI cards update to show 2014-only totals.
- Check the line chart. It now narrows to show only 2014 months.
- Check the bar charts. They re-rank countries and products based on 2014 data only.
Every visual on the page responded to your single click. That is the power of slicers.
- Now click Government in the Segment slicer while 2014 is still selected.
- All charts and KPIs now show only Government segment sales in 2014.
- To clear a slicer filter, hover over the slicer header and click the eraser icon that appears.
- Clear all slicer selections now so the dashboard returns to showing all data.
Why did everything update at once?
Power BI uses cross-filtering by default. When a slicer sends a filter (like Year = 2014), every visual that uses data from the same table automatically respects that filter.
Your DAX measures (Total Sales, Total Profit, etc.) are designed to respond to filter context. That is why the KPI cards recalculated instantly.
Visuals not updating when you click a slicer?
Make sure all visuals are on the same report page. Slicers only filter visuals on their own page.
If a specific chart is not responding, click the slicer, go to Format ribbon, click Edit interactions, and make sure the filter icon (not the "none" icon) is active on the stubborn visual.
Need more help? My Power BI slicer is not filtering other visuals on the page.
Polish the layout with a theme, title, and alignment
Your dashboard is functional, but a polished appearance makes it portfolio-ready. A consistent color theme, clean alignment, and a clear title communicate professionalism.
- Clear any active slicer selections so you see the full unfiltered dashboard.
- Press Ctrl+A to select all visuals on the canvas.
- Go to the Format ribbon tab at the top.
- Click Align and choose alignment options to distribute your visuals evenly (try Distribute horizontally for the KPI cards row).
Your visuals should now sit in cleaner, more evenly spaced positions.
- Click the View tab in the top ribbon.
- Click Themes and browse the built-in options.
- Select a professional theme such as Executive or City park.
The entire dashboard updates its colors instantly. Every chart, card, and slicer now shares a cohesive palette.
- Click the Insert tab in the top ribbon.
- Click Text box.
- An empty text box appears on the canvas. Type Sales Performance Dashboard into it.
- Increase the font size to around 20-24pt using the text formatting toolbar that appears above the text box.
- Drag the text box to the very top of the canvas, above your KPI cards.
Your dashboard now has a clear title that tells viewers exactly what they are looking at.
- Click on your line chart. Check that its title reads Monthly Sales Trend. If not, double-click the title area on the visual to edit it.
- Check the bar charts have titles Sales by Country and Sales by Product.
- To remove unnecessary gridlines, select a chart, open the Format pane (paint roller icon), expand the Gridlines section, and toggle off any gridlines that add clutter.
- Remove unnecessary axis labels the same way. Under the X-axis or Y-axis section in the Format pane, toggle off any axis titles that repeat information already clear from context.
Less is more with gridlines
Gridlines help when exact values matter, but for a high-level executive dashboard, they add visual noise. Removing them puts the focus on trends and comparisons rather than precise numbers.
- Press Ctrl+S to save your .pbix file.
Before you do your final check, predict what you expect to see: a titled dashboard with consistent colors, four KPI cards at the top, charts below, and slicers that filter everything on click.
- Click 2014 in the Year slicer.
- Confirm all four KPI cards update, the line chart narrows to 2014 months only, and the bar charts re-rank.
- Click a Segment slicer option and confirm everything filters again.
- Clear the slicer selections using the eraser icon on each slicer header. The dashboard returns to showing all data.
Your dashboard is complete. It has headline KPIs, trend analysis, breakdowns, interactivity, and professional polish.
Theme not applying to all visuals?
If some visuals kept their old colors after applying a theme, you may have manually set colors on those visuals earlier. Select the stubborn visual, open the Format pane, find the color setting, and click Reset to default so the theme takes over.
Still having trouble? Help me fix my Power BI theme not applying to all visuals.
Secret mission
Add a Top 5 Products Profit Table
Your dashboard shows the big picture, but hiring managers want to see you can surface specific insights too. Can you add a formatted table that highlights exactly which products drive the most profit, complete with visual data bars?
Clean Up Your Resources
Clean Up Your Resources
This project runs entirely on Power BI Desktop, which is free local software. There are no cloud resources, no paid services, and no ongoing costs.
Resources you used:
- Your saved .pbix dashboard file (local file on your computer).
Keep everything running
No action needed. Choose this if you want to keep your dashboard for your portfolio or plan to continue improving it.
- Save your file by pressing Ctrl+S in Power BI Desktop.
- Your .pbix file stays on your computer wherever you saved it.
- You can reopen it anytime by double-clicking the file or using File then Open report in Power BI Desktop.
Pause - I'll come back to this later
Save your work and close Power BI Desktop to free up system memory. Your file will be waiting when you come back.
- Press Ctrl+S to save your dashboard.
- Close Power BI Desktop.
- Your .pbix file remains on disk. Reopen it anytime to pick up where you left off.
Delete - I don't want to use this again
Remove your project file entirely. You can always rebuild the dashboard later using the same built-in sample data.
- Close Power BI Desktop without saving (or save first if you want a backup).
- Open File Explorer and navigate to where you saved your .pbix file.
- Right-click the file and select Delete.
- Empty your Recycle Bin if you want to remove it permanently.
Nice Work!
Nice Work!
You just built a complete, interactive sales dashboard in Power BI Desktop. From raw financial data to a polished, filterable report that any hiring manager would recognize as real reporting work.
You've learned how to:
- Clean raw data with Power Query and write DAX measures from scratch to create calculated KPIs that respond correctly to slicer filters.
- Build KPI cards, a line chart for revenue trends, and bar charts that rank performance by country and product.
- Add interactive slicers and apply professional formatting to transform a static report into a decision-making tool viewers can explore on their own.
- Secret Mission: Added a Top 5 Products table using Top N filters and conditional data bars for advanced visual formatting.
Ready to quiz yourself?