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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…