Forum Discussion
Solved
SETTING UP PAGE FILTER
I would like to know if I can filter page using String (one of my columns) in exclude rows that end with 3 or end with S or end with B
thank you
- There is a workaround to do it. Create a new column
If( right(string,1)="3","exclude",If( right(string,1)="S","exclude",If( right(string,1)="B","exclude","include"))).
This will give you include and exclude. Use this column in page level filter. Hope this solution works for you
3 Replies
How do I set advance filter on page level to exclude all ending with 3. Filter is for a string.
kohlivinayakResolver I
Hi patyk
I created a new column and used it for the filter, below is the code
filter = SWITCH(RIGHT(Table2[Column1],1),
"3", "Ending with 3", "not ending with 3")Thanks
Vinayak
Shantanu00007Helper I
There is a workaround to do it. Create a new column
If( right(string,1)="3","exclude",If( right(string,1)="S","exclude",If( right(string,1)="B","exclude","include"))).
This will give you include and exclude. Use this column in page level filter. Hope this solution works for you
