KPI visual in Power BI - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate Total Sales for Current Year

You have a sales table with a column SalesAmount and a date column OrderDate. You want to create a measure that calculates the total sales for the current year only.

Which DAX measure will correctly calculate this?

A Total Sales CY = SUMX(FILTER(Sales, YEAR(Sales[OrderDate]) = YEAR(TODAY())), Sales[SalesAmount])

B Total Sales CY = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, YEAR(Sales[OrderDate]) = YEAR(TODAY())))

C Total Sales CY = CALCULATE(SUM(Sales[SalesAmount]), YEAR(Sales[OrderDate]) = YEAR(TODAY()))

D Total Sales CY = SUM(Sales[SalesAmount])

💡 Hint

Use CALCULATE with FILTER to apply a row context filter on the date column.

Option B uses CALCULATE with FILTER to correctly filter rows where the year of OrderDate matches the current year. Option B tries to use a boolean expression directly inside CALCULATE, which is invalid. Option B uses SUMX with FILTER, which works but is less efficient. Option B sums all sales without filtering.

❓ visualization

intermediate

Best Practice for KPI Visual Color Usage

You want to create a KPI visual in Power BI that shows sales growth. Which color usage follows best practices for accessibility and clarity?

A Use red for positive growth and green for negative growth.

B Use random bright colors for each KPI to attract attention.

C Use only blue shades for all KPI values to keep it simple.

D Use green for positive growth, red for negative growth, and ensure color contrast meets accessibility standards.

💡 Hint

Think about common color meanings and accessibility.

Green usually means good or positive, red means bad or negative. Ensuring color contrast helps users with visual impairments. Option D follows these best practices. Option D reverses common meanings. Option D lacks differentiation. Option D can confuse users and reduce clarity.

❓ data_modeling

advanced

Modeling Data for KPI Visual with Multiple Date Filters

You have sales data and a separate date table. You want to create a KPI visual that shows sales for the current month and compares it to the previous month. What is the best data modeling approach?

A Create a relationship between sales and date tables on the date column, mark the date table as a date table, and use time intelligence DAX functions.

B Keep sales and date tables unlinked and use LOOKUPVALUE in measures to get dates.

C Merge sales and date tables into one big table to simplify filtering.

D Create multiple disconnected date tables for each KPI and use USERELATIONSHIP in measures.

💡 Hint

Think about how Power BI uses relationships and date tables for time intelligence.

Option A is best practice: a single date table linked to sales allows use of built-in time intelligence functions like SAMEPERIODLASTMONTH. Option A is inefficient and error-prone. Option A can cause data duplication and performance issues. Option A complicates the model unnecessarily.

🔧 Formula Fix

advanced

Identify the Error in KPI Measure Calculation

Given this DAX measure for a KPI visual:

Sales Growth % = DIVIDE(SUM(Sales[SalesAmount]) - SUM(Sales[SalesAmount]), SUM(Sales[SalesAmount]), 0)

What is the main issue causing incorrect KPI output?

A The numerator subtracts the same sum from itself, always resulting in zero.

B The measure lacks a FILTER to limit data to current and previous periods.

C SUM function is used incorrectly with two arguments.

D The DIVIDE function is missing the alternate result parameter.

💡 Hint

Look carefully at the subtraction in the numerator.

The numerator subtracts SUM(Sales[SalesAmount]) from itself, so it always equals zero, making the growth always zero. Option A is incorrect because DIVIDE has a third argument (0) as alternate result. Option A is wrong because SUM does not accept two arguments, but here the second argument is inside DIVIDE, so syntax is valid. Option A is a modeling suggestion but not the main error.

🎯 Scenario

expert

Designing a KPI Visual for Multi-Category Sales Growth

You need to create a KPI visual that shows sales growth for multiple product categories side by side. The data model has a sales table and a product category table. How should you design the KPI visual and measures to best support this?

A Create a calculated column in sales table for growth and use a card visual for each category.

B Create separate KPI visuals for each category with hardcoded filters in each visual.

C Create a measure that calculates sales growth filtered by the selected category, then use a matrix visual with categories as rows and the KPI measure as values.

D Use a slicer to select one category at a time and show a single KPI card visual.

💡 Hint

Think about dynamic filtering and scalability for multiple categories.

Option C allows dynamic calculation of sales growth per category and displays them side by side in a matrix, which is scalable and user-friendly. Option C is inefficient and hard to maintain. Option C uses calculated columns which are static and not recommended for dynamic KPIs. Option C limits user to one category at a time, reducing insight.

Practice

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