0
0
Power BIbi_tool~15 mins

KPI visual in Power BI - Real Business Scenario

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Scenario Mode
👤 Your Role: You are a sales analyst at a retail company.
📋 Request: Your manager wants a simple dashboard showing the current month's total sales compared to the previous month, with a clear indicator if sales have increased or decreased.
📊 Data: You have monthly sales data with columns: Month, Year, and Sales Amount.
🎯 Deliverable: Create a Power BI report page with a KPI visual showing total sales for the current month, the sales for the previous month as a target, and an indicator arrow showing increase or decrease.
Progress0 / 6 steps
Sample Data
YearMonthSales Amount
2024110000
2024212000
2024315000
2024413000
2024516000
2024617000
2024718000
2024819000
2024921000
20241022000
20241123000
20241225000
1
Step 1: Load the sales data into Power BI and ensure the data types are correct: Year and Month as whole numbers, Sales Amount as decimal number.
Use Power BI's data import wizard to load the table. Check data types in Power Query or Data view.
Expected Result
Sales data is loaded with correct data types.
2
Step 2: Create a calculated measure for Total Sales.
Total Sales = SUM('Sales'[Sales Amount])
Expected Result
Measure 'Total Sales' sums all sales amounts.
3
Step 3: Create a calculated measure for Previous Month Sales using DAX.
Previous Month Sales = CALCULATE([Total Sales], PREVIOUSMONTH(DATE('Sales'[Year], 'Sales'[Month], 1)))
Expected Result
Measure 'Previous Month Sales' shows sales for the month before the current filter context.
4
Step 4: Add a slicer for Year and Month to select the current month to analyze.
Insert slicers for 'Year' and 'Month' columns from the Sales table.
Expected Result
User can select a specific month and year to view sales.
5
Step 5: Insert a KPI visual on the report page.
Set 'Indicator' to 'Total Sales', 'Trend axis' to a date column created as DATE('Sales'[Year], 'Sales'[Month], 1), and 'Target goals' to 'Previous Month Sales'.
Expected Result
KPI visual shows current month sales, previous month sales as target, and an arrow indicating increase or decrease.
6
Step 6: Format the KPI visual for clarity: use green color for increase, red for decrease, and add data labels.
Use KPI visual formatting pane to set colors and labels.
Expected Result
KPI visual clearly shows sales performance with color-coded indicators.
Final Result
-----------------------------
|      SALES KPI DASHBOARD   |
|---------------------------|
| Current Month Sales: 22,000|
| Previous Month Sales: 21,000|
| Indicator: ↑ (Increase)    |
-----------------------------
✓Sales increased from previous month by 1,000 units.
✓The KPI visual clearly shows positive sales growth for the selected month.
Bonus Challenge

Add a card visual showing the percentage change in sales compared to the previous month.

Show Hint
Create a measure: Sales Change % = DIVIDE([Total Sales] - [Previous Month Sales], [Previous Month Sales], 0) and format as percentage.