Forum Discussion
How to add Multiple Contain Filters in PowerBI
Hey woofwoof123,
Sounds like your issue is you want to have more than four clauses (?) in your advanced filtering? If so, bit of a quirk but what you can do is select four options in your basic filtering, then convert it to an advanced filter. When you do that, you will then see four different clauses.
This is an example from a pbix I have. (Ignore the nerdy context haha)
Let me know if that's not what you were looking for or if I didn't explain myself well.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Memorable MemberHey woofwoof123,
Sounds like your issue is you want to have more than four clauses (?) in your advanced filtering? If so, bit of a quirk but what you can do is select four options in your basic filtering, then convert it to an advanced filter. When you do that, you will then see four different clauses.
This is an example from a pbix I have. (Ignore the nerdy context haha)
Let me know if that's not what you were looking for or if I didn't explain myself well.
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.