Cross-filtering between visuals in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable cross-filtering between two visuals in Power BI.

Power BI

VisualInteractions.SetVisualInteraction([1])

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

ACrossHighlight

BDrillDown

CNoInteraction

DCrossFilter

Attempts:

3 left

💡 Hint

Common Mistakes

Using CrossHighlight instead of CrossFilter causes highlight effect without filtering.

NoInteraction disables filtering between visuals.

CrossFilter enables cross-filtering behavior between visuals in Power BI.

2fill in blank

medium

Complete the DAX measure to calculate total sales filtered by selected product category.

Power BI

Total Sales Selected = CALCULATE(SUM(Sales[Amount]), [1](Products[Category]))

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

AALLSELECTED

BVALUES

CREMOVEFILTERS

DFILTER

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER without a proper filter expression causes errors.

REMOVEFILTERS removes filters instead of applying them.

ALLSELECTED returns the selected values in the current filter context, enabling cross-filtering.

3fill in blank

hard

Fix the error in the DAX formula to correctly apply cross-filtering on the 'Region' column.

Power BI

Sales by Region = CALCULATE(SUM(Sales[Amount]), [1](Region[Name]))

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

AFILTER

BVALUES

CALL

DSELECTEDVALUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using ALL removes filters, breaking cross-filtering.

SELECTEDVALUE returns a single value, not a table.

VALUES returns the distinct values of Region[Name] in the current filter context, enabling cross-filtering.

4fill in blank

hard

Fill both blanks to create a measure that shows sales only for selected regions and products.

Power BI

Filtered Sales = CALCULATE(SUM(Sales[Amount]), [1](Region[Name]), [2](Products[Name]))

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

AVALUES

BALL

CFILTER

DREMOVEFILTERS

Attempts:

3 left

💡 Hint

Common Mistakes

Using FILTER without a proper filter expression causes errors.

Using REMOVEFILTERS disables filtering.

VALUES returns selected regions and products for cross-filtering.

5fill in blank

hard

Fill all three blanks to create a measure that calculates sales filtered by selected year, region, and product category.

Power BI

Sales Filtered = CALCULATE(SUM(Sales[Amount]), [1](Calendar[Year]), [2](Region[Name]), [3](Products[Category]))

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

AVALUES

BFILTER

CALLSELECTED

DREMOVEFILTERS

Attempts:

3 left

💡 Hint

Common Mistakes

Using REMOVEFILTERS removes filters and breaks cross-filtering.

Using ALL removes filters instead of applying them.

ALLSELECTED respects year selection, VALUES returns selected regions and product categories for cross-filtering.