Forum Discussion
Helper IOr Condition on page filter
That makes sense. Yet, I was hoping something that needed fewer manipulations (adding each filter individually is a bit repetitive) but I guess I can do it.
The other solution I found is to create a new column by concatenating FD1 and FD2. Then I added an advanced filter on the page and that requires the concatenated variable to contains "X".
Community Champion
Create a calculated column/ custom column to identify if the row needs to filter or not filter.
Example
FilterCondition =
IF (
table[FD1] = X
|| table[FD2] = X,
"Filter",
"Not Filter"
)
Then apply this newly created calculated column in page level filter.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
Helper IHi nandukrishnavs , thanks for your fast reply!
The fact is that I need to be able to change the filter. First I can do it with X but then Y, then Z...
If I need to create a column every time, that's not really effective...
Btw,
I find this helpful topic https://community.powerbi.com/t5/Desktop/Or-Condition-on-filter/m-p/833445#M400287
But it's not working on filter on the page. v-lid-msft