Welcome to Excel Jet Consult Blog Post. In this tutorial, we will learn how to use the Advanced Filter in Power BI
Below is the report we want to apply multiple advanced filter
We want to filter the Account Manager names that start with P or S
Hover the mouse right of the Account Manager in the Filters and click on Expand
In the Filter Type drop-down, select Advanced Filtering
In the Show items when the value drop-down, select start with
In the box below type in the main criteria P
Check the Or and select start with
In the box below, type in the second criteria S
Click on Apply filter
From the caption above, we can see that the advanced filter has been applied based on the specified criteria
This is really intereѕting. Look forward to mօre of your magnificent excel post.