Key influencers visual in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to add the Key Influencers visual to the report.

Power BI

Insert a [1] visual from the Visualizations pane.

Drag options to blanks, or click blank then click option'

ATable

BKey Influencers

CPie Chart

DBar Chart

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing a bar chart instead of the Key Influencers visual.

Selecting a pie chart which shows proportions but not influencers.

The Key Influencers visual is specifically designed to analyze factors that influence a selected metric.

2fill in blank

medium

Complete the step to select the metric to analyze in the Key Influencers visual.

Power BI

Drag the [1] field into the 'Analyze' bucket of the Key Influencers visual.

Drag options to blanks, or click blank then click option'

ASales Amount

BCategory

CDate

DCustomer Name

Attempts:

3 left

💡 Hint

Common Mistakes

Dragging a category field instead of a numeric metric.

Using a date field which is not a metric.

The 'Analyze' bucket requires the metric you want to understand, such as Sales Amount.

3fill in blank

hard

Fix the error in the DAX formula to create a measure for the Key Influencers visual.

Power BI

Total Sales = SUM([1])

Drag options to blanks, or click blank then click option'

AAmount

BSales Amount

CSales[Amount]

DSales[Total]

Attempts:

3 left

💡 Hint

Common Mistakes

Using just the column name without the table.

Using an incorrect column or table name.

The SUM function requires a column reference in the format Table[Column], such as Sales[Amount].

4fill in blank

hard

Fill both blanks to filter the Key Influencers visual to only show data for 2023.

Power BI

Filter = FILTER(Sales, YEAR(Sales[Date]) [1] 2023 && Sales[Region] [2] "North")

Drag options to blanks, or click blank then click option'

A=

B>

CAND

D==

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' instead of '=' for year comparison.

Using '==' instead of '=' for equality comparisons.

The YEAR function is compared with '=' to select 2023. The region comparison uses '=' for equality in DAX.

5fill in blank

hard

Fill all three blanks to create a calculated column that categorizes sales as High, Medium, or Low for the Key Influencers visual.

Power BI

Sales Category = IF(Sales[Amount] [1] 1000, "High", IF(Sales[Amount] [2] 500, "Medium", [3]))

Drag options to blanks, or click blank then click option'

A>

B>=

C"Low"

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for comparisons.

Not quoting the 'Low' string.

The first condition checks if Amount is greater than 1000 for 'High'. The second checks if Amount is greater or equal to 500 for 'Medium'. Otherwise, it assigns 'Low'.