Multiple Conditions in Advanced Filtering when Basic has only one Condition?

[RYU209]

Hello,

I have a Filter that currently only has one condition in the existing dataset. However, this won't always be the case and I'm going to need to filter on more than 2 conditions eventually. How can I setup Advanced Filtering with more than 2 conditions?

I know that there is a workaround with Basic Filtering where the user checks more than 2 selections then switches to Advanced Filtering but right now I only have one filter condition available to me in Basic Filtering so this isn't an option.

[Anonymous · Accepted solution]

Hi @RYU209 ,

I suggest you to create a measure, then add this measure into visual level filter and use it as a filter to filter your visual.

For reference:

How to use Measure as a Filter in Power BI

Applying a measure filter in Power BI

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.