NEW! FREE 1 hour Data Cleaning Course for Beginner Users Watch now 

Power BITutorials

Learn How to Filter Records Using Power Query

1 Mins read

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.

 

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.

LOAD DATA IN POWER QUERY

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

FILTER TEXT

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.

FILTER ROWS WINDOW

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.

 

The picture below shows the expected result for filtering text. Click on the Close & Apply button to save the changes.

DATA TABLE AFTER FILTERING TEXT

You can learn more :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…