Forum Discussion
Create an advanced filter with more than 2 options
Hello,
the advanced filter allows to create a filter on an text attribute, specifing start by AAA or Start by BBB
but, what if i want 4 options? The PBI Interface doesn't allow to add conditions, so that in this case i would place start by AAA or start by BBB and then add other 2 options for or start by CCC and or start by DDD
Regards
Anonymous -
Oh that is interesting...
For me if I went directly to Advanced filtering I was only shown two criteria like what your're experiencing. However, if you start with Basic filtering and then select the values for your criteria and then select Advanced filtering those criteria show.
I didn't expect that. I figured you would have to write the logic in your DAX.
17 Replies
- ChrisMendoza
Resident Rockstar
Anonymous -
Oh that is interesting...
For me if I went directly to Advanced filtering I was only shown two criteria like what your're experiencing. However, if you start with Basic filtering and then select the values for your criteria and then select Advanced filtering those criteria show.
I didn't expect that. I figured you would have to write the logic in your DAX.
Hi everyone,
this thread was created in 2019, and here we are 4 years later in 2023 with the same situation.
The solution of ChrisMendoza is obviously helpful, but to me, it just feels like a workaround. I expect better from a big company like Microsoft. It can't be that difficult to add a "+" (plus) button or something similar to add more options when using the Advanced filtering options, can it?!
- jdbuchanan71
Super User
Anonymous
You can vote for the feature in the ideas area here.
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=866ea64e-d078-47d0-8221-3db1a8209fbe
- jonespossibly
Advocate I
This is insane.
Why the hell would this not work in the way everyone in the known universe (except for the power BI UX designers) expects it to work?
What if i want to filter a table on a value that might not exist on the table currently, but could if the criteria was right? It won't exist in the basic filter list. But if the UI was written in some even mildly sensible way, I could enter it into the advanced filtering to filter it if and when it does occur.
its sh*t like this that makes me look more longingly towards other BI products on an almost daily basis recently
I just want an easy and out of the box way to do simple OR filtering. Created On > 01/01/2024 OR Status = Complete. I can't find any way to do this without code or a long-winded data manipulation. 😞
Hello ChrisMendoza ,
you are right! :D
This is almost funny, because imagine you have a long list with
AAAsometext1
AAAsometext2
AAAsometext3
...
AAAsometextn
You can select 4 choices as is AAAsometextX, and then, in the advanced filtering, change to contain and change the strings for AAA, BBB, CCC and DDD :D:D
Regards
- jdbuchanan71
I just checked and it is still working for me. This is something you do on PowerBI.com in the browser, not in PowerBI desktop.
LinLinBI can't get this to work - selecting 4 basic filter conditions and then swapping over to advanced filter - shows no filters are chosen in advanced. Did something change? I've tried a couple of different fields.
- jdbuchanan71
Looks like it did change, yes. No longer works for me either.
- LinLinB
I tried a few things. I FINALLY got it to work. You have to drag the field you would like to filter by TWICE into the filter column. So the first instance stays unfiltered (being used by the viz directly in some way).
The second instance is the one you can modify for multiple Advanced Filtering and numerous cases. I hope this helps.
- Roger_M
It is not working for me on the specific visual (bottom list), online version or desktop, but it works on the fiters for this page though.
How woudl I write the DAX for it for T-603, T-610, T-630 and T-640?
