Forum Discussion
Solved
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.
Hi Heinrich,
You could create a calculated column that is
Text Check = IF(ISERROR(VALUE('Table1'[Field 1])), "TEXT", "NUMBER")
Then place this into a a filter and you can choose to filter out rows where the entire cell content for that row is a number.
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
