Filtering rows in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does filtering rows mean in Power BI?

Filtering rows means selecting only the data that meets certain conditions, so you see just the information you need.

beginner

How do you apply a filter to a table visual in Power BI?

You drag a field to the Filters pane and set the condition, like choosing specific values or ranges to show only matching rows.

beginner

What is a slicer in Power BI?

A slicer is a visual filter that lets users click buttons or select items to filter data on the report page easily.

intermediate

Write a simple DAX formula to filter rows where Sales are greater than 1000.

FILTER(SalesTable, SalesTable[Sales] > 1000)

beginner

Why is filtering rows important in reports?

Filtering rows helps focus on relevant data, making reports clearer and easier to understand, like looking only at your favorite items in a store.

Which Power BI feature lets you filter data by clicking buttons on the report?

A Calculated Column

B Measure

C Slicer

D Data Model

A slicer is a visual filter that allows users to filter data interactively by clicking options.

What does the FILTER function in DAX do?

A Changes the color of a visual

B Creates a new table with rows that meet a condition

C Adds a new column to a table

D Deletes rows from the data source

FILTER returns a table containing only rows that satisfy the given condition.

Where do you set filters for a visual in Power BI Desktop?

A Filters pane

B Data view

C Model view

D Bookmarks pane

The Filters pane is where you add and adjust filters for visuals.

If you want to see only sales from 2023, what type of filter would you use?

A Date filter

B Text filter

C Numeric filter

D No filter needed

A date filter lets you select data from a specific year like 2023.

Which of these is NOT a way to filter rows in Power BI?

A Using slicers

B Applying filters in the Filters pane

C Writing DAX FILTER expressions

D Changing the data source file format

Changing the data source file format does not filter rows in Power BI.

Explain how filtering rows helps improve a Power BI report.

Think about how you choose only what you want to see in a list.

Describe three ways to filter rows in Power BI.

One way is visual, one is interactive, and one is formula-based.