Visual-level filters in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to apply a visual-level filter that shows only sales greater than 1000.

Power BI

FILTER(Sales, Sales[Amount] [1] 1000)

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

A<=

B>

C=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '=' instead of '>' causes the filter to show only sales exactly equal to 1000.

Using '<' or '<=' will show sales less than or equal to 1000, which is incorrect.

The visual-level filter should show sales where the amount is greater than 1000, so the correct operator is >.

2fill in blank

medium

Complete the code to filter the visual to show only products in the 'Electronics' category.

Power BI

FILTER(Products, Products[Category] [1] "Electronics")

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

A<>

B<

C>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' would exclude 'Electronics' instead of including it.

Using '>' or '<' does not make sense for text comparison here.

The filter should select products where the category equals 'Electronics', so the correct operator is '='.

3fill in blank

hard

Fix the error in the DAX expression to correctly filter sales for the year 2023.

Power BI

FILTER(Sales, YEAR(Sales[Date]) [1] 2023)

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

A=

B==

C===

D=>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '==' or '===' causes syntax errors in DAX.

Using '=>' is invalid syntax.

In DAX, the correct equality operator is '=', not '==', '===', or '=>'.

4fill in blank

hard

Fill both blanks to filter the visual to show sales where the amount is between 500 and 2000.

Power BI

FILTER(Sales, Sales[Amount] [1] 500 && Sales[Amount] [2] 2000)

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' instead of '>=' excludes 500 from the results.

Using '<' instead of '<=' excludes 2000 from the results.

The filter should include sales amounts greater than or equal to 500 and less than or equal to 2000.

5fill in blank

hard

Fill all three blanks to filter the visual to show only customers from 'USA' with sales greater than 1000 and less than 5000.

Power BI

FILTER(Sales, Sales[Country] [1] "USA" && Sales[Amount] [2] 1000 && Sales[Amount] [3] 5000)

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

A=

B>

C<

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<=' or '>=' changes the range and may include unwanted values.

Using '<>' for country excludes 'USA' instead of including it.

The filter selects sales where the country equals 'USA', the amount is greater than 1000, and less than 5000.