Filtering rows in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to filter the Sales table for only rows where Quantity is greater than 10.

Power BI

FILTER(Sales, Sales[Quantity] [1] 10)

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

A<

B=

C>

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using < instead of > which filters the wrong rows.

Using = which only keeps rows where Quantity equals 10.

The FILTER function keeps rows where the condition is true. We want Quantity greater than 10, so we use >.

2fill in blank

medium

Complete the code to filter the Customers table for rows where Country equals 'USA'.

Power BI

FILTER(Customers, Customers[Country] [1] "USA")

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

A<>

B<

C>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using <> which means 'not equal' and filters out USA.

Using > or < which are for numeric comparisons.

To filter rows where Country is exactly 'USA', use the equals operator =.

3fill in blank

hard

Fix the error in the code to filter the Orders table for rows where OrderDate is after January 1, 2023.

Power BI

FILTER(Orders, Orders[OrderDate] [1] DATE(2023, 1, 1))

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

A>

B=

C<=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using <= which filters dates before or on January 1.

Using = which only filters orders exactly on January 1.

To get orders after January 1, 2023, use the > operator to compare dates.

4fill in blank

hard

Fill both blanks to filter the Products table for rows where Price is between 50 and 100 inclusive.

Power BI

FILTER(Products, Products[Price] [1] 50 && Products[Price] [2] 100)

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

A>=

B<

C<=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using > and < which exclude the boundary values.

Mixing up the operators and filtering wrong ranges.

Price should be greater than or equal to 50 and less than or equal to 100 to include both ends.

5fill in blank

hard

Fill all three blanks to filter the Employees table for rows where Department is 'Sales' and Age is greater than 30.

Power BI

FILTER(Employees, Employees[[1]] [2] "[3]" && Employees[Age] > 30)

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

ADepartment

B=

CSales

DPosition

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'Position' instead of 'Department' as the column name.

Using <> instead of = which filters out Sales.

Forgetting to put 'Sales' in quotes.

The filter checks if Department equals 'Sales' and Age is greater than 30.