Forum Discussion
Filters: Exclude Numbers
Hello
Is it possible to exclude numbers or only contain letters in a filter.
Regards
Heinrich
Hi Heinrich so, either take my first solution, there are 10 possible numbers that any number can start with and in advanced filtering say starts with instead of equals or contains.
Or create a Calculated Column
VizFilter =
if(left(Table[YourColumn], 1)
in {"1","2","3","4", "5", "6", "7", "8", "9", "0"}, 1, 0)
Use it as a filter.
13 Replies
A dirty solution, but nonetheless:
In the filter, you choose filter type: basic, deselct everything, pick 10 entriesThen, change the filter type to Advanced:
Change "is" to "does not contain" and put in 0,1,2,3,4,5 etc. and apply filter
Hello olgad
Thank you but there are multiple digits so one single number is to few.
Do you have the possibility to expand this solution?
Regards
Heinrich
A similar solution to olgad but this moves the logic into a measure instead, and works for some kinds of visuals.
Create a measure like this:
visualFilter =
IF(CONTAINSSTRING([value], "0")
|| CONTAINSSTRING([value], "1")
|| CONTAINSSTRING([value], "2")|| CONTAINSSTRING([value], "3")
|| CONTAINSSTRING([value], "4")
|| CONTAINSSTRING([value], "5")
|| CONTAINSSTRING([value], "6")
|| CONTAINSSTRING([value], "7")
|| CONTAINSSTRING([value], "8")
|| CONTAINSSTRING([value], "9"),
1,
0
)
Then make this measure a filter on the visual and only include records where [visualFilter] is 0
Hello kpost
Thank you but there are multiple digits so one single number is to few.
Do you have the possibility to expand this solution?
Regards
HeinrichMy solution filters on whether there are ANY numbers, anywhere in the field. It is not checking whether the field is equal to 0,1,2,3,4,5,6,7,8,9. Rather, it is checking whether those characters are found anywhere in the string.
Hello d_rohlfs
Thank you very much.
With "Number" do you mean a specific number or is this a variable?
I can not tell you the number exactly.Regards
Heinrich
