Learn How to Filter Records Using Power Query

Filter records are a feature of Power Query that allows you to filter the data from your data table. Let’s see how to filter the records in Power Query with an example.

MICROSOFT POWER BI FOR BEGINNERS
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

Table of Contents

Filter Records By Power Query

Step 1: Load Data in Power Query

Sometimes the data table is too huge and you do not want to view or access the entire data table. Therefore, the best way is to filter out data and keep only the desired data.

Load the data in Power Query as shown in the picture below. Go through the table and check what data you want to keep and decide accordingly the conditions to filter out data.

Step 2: Filter data using Text Filters

To filter the data using the text filter, go to –

Filter arrow of Name column > Text Filters > Begins with > OK

Step 3: Filter Text by applying different conditions

When you go to the text filter, a Filter Rows Window gets open as shown below. In this case, as we want to apply multiple conditions, we will select the Advanced options for filtering.

Here, we have selected the name staring from letter ‘S’ from the Name column and also selected the HRD from the division column and chosen the OR operator for filtering.

Step 4: Close & Apply

As we have chosen OR operator, it will select all the names starting from ‘S’ irrespective of their division and will also select all the divisions having the value‘HRD’irrespective of the names.