Bird
Raised Fist0
Power BIbi_tool~15 mins

KPI visual in Power BI - Real Business Scenario

Choose your learning style10 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.

Practice

(1/5)
1. What is the main purpose of a KPI visual in Power BI?
easy
A. To show a single important number with trend and target
B. To display detailed tables of data
C. To create complex data models
D. To write DAX formulas

Solution

  1. Step 1: Understand KPI visual purpose

    KPI visuals focus on showing one key number that matters most for quick insights.

  2. Step 2: Compare options

    Options A, B, and C describe other Power BI features, not KPI visuals.

  3. Final Answer:

    To show a single important number with trend and target -> Option A

  4. Quick Check:

    KPI visual = single key number with trend [OK]
Hint: KPI = one key number with trend and target [OK]
Common Mistakes:
  • Confusing KPI with tables or charts
  • Thinking KPI shows multiple numbers
  • Assuming KPI is for data modeling
2. Which of the following is the correct way to add a KPI visual in Power BI?
easy
A. Write a DAX formula named KPI()
B. Select the KPI visual icon from the Visualizations pane
C. Use the Table visual and rename it KPI
D. Add a slicer and set it to KPI mode

Solution

  1. Step 1: Identify how to add visuals

    Power BI lets you add visuals by selecting icons from the Visualizations pane.

  2. Step 2: Confirm KPI visual icon usage

    The KPI visual has its own icon; you do not write DAX or rename other visuals.

  3. Final Answer:

    Select the KPI visual icon from the Visualizations pane -> Option B

  4. Quick Check:

    Add KPI visual = select icon [OK]
Hint: Add visuals by clicking icons in Visualizations pane [OK]
Common Mistakes:
  • Trying to create KPI by DAX formula alone
  • Renaming other visuals to KPI
  • Using slicers to create KPI visuals
3. Given a KPI visual showing Sales Amount with a target of 100000, if the actual sales are 120000, what color and arrow direction will the KPI show by default?
medium
A. Green color with upward arrow
B. Yellow color with sideways arrow
C. Red color with downward arrow
D. Blue color with upward arrow

Solution

  1. Step 1: Understand KPI color and arrow logic

    When actual value exceeds target, KPI shows green color and upward arrow indicating good performance.

  2. Step 2: Apply to given values

    Actual sales 120000 > target 100000, so KPI shows green and upward arrow.

  3. Final Answer:

    Green color with upward arrow -> Option A

  4. Quick Check:

    Actual > Target = Green + Up arrow [OK]
Hint: Actual above target = green and up arrow [OK]
Common Mistakes:
  • Confusing red with good performance
  • Thinking arrow points down when above target
  • Assuming yellow color for above target
4. You created a KPI visual but it shows no trend line. What is the most likely reason?
medium
A. The KPI visual does not support trend lines
B. You forgot to set the target value
C. You did not add a Trend axis field
D. You used a table visual instead of KPI

Solution

  1. Step 1: Check KPI visual requirements

    KPI visuals need a Trend axis field to show the trend line over time or categories.

  2. Step 2: Identify missing field

    If no trend line appears, likely the Trend axis field was not added.

  3. Final Answer:

    You did not add a Trend axis field -> Option C

  4. Quick Check:

    No trend line = missing Trend axis field [OK]
Hint: Add Trend axis field to show trend line [OK]
Common Mistakes:
  • Assuming target value controls trend line
  • Thinking KPI visual cannot show trends
  • Using wrong visual type
5. You want to create a KPI visual that shows monthly sales progress with a target line and color changes for above or below target. Which steps should you follow?
hard
A. Add Sales to Filters, Date to Target goals, Target to Indicator
B. Add Date to Indicator, Sales to Trend axis, Target to Filters
C. Add Target to Indicator, Sales to Trend axis, Date to Legend
D. Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals

Solution

  1. Step 1: Assign fields correctly in KPI visual

    Indicator shows the main value (Sales), Trend axis shows time (Date), Target goals show the target measure.

  2. Step 2: Verify correct field placement

    Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals places Sales in Indicator, Date in Trend axis, and Target in Target goals, enabling progress and color changes.

  3. Final Answer:

    Add Sales measure to Indicator, add Date to Trend axis, add Target measure to Target goals -> Option D

  4. Quick Check:

    Indicator=Sales, Trend=Date, Target=Target [OK]
Hint: Indicator=Value, Trend=Time, Target=Goal for KPI [OK]
Common Mistakes:
  • Mixing up Indicator and Trend axis fields
  • Putting target in filters instead of Target goals
  • Using wrong fields for legend or filters
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard