Forum Discussion
Filters: Exclude Numbers
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.
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
Heinrich
My 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.
Thank you kpost
It was my error. I wanted to filter out every name that starts with a number
Do you have such a solution
Regards
HeinrichHi 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.