Forum Discussion

Heinrich's avatar
Heinrich
Post Partisan
2 years ago
Solved

Filters: Exclude Numbers

Hello Is it possible to exclude numbers or only contain letters in a filter. Regards Heinrich
Show and Tell
Tips and Tricks
Tutorial Requests
  • d_rohlfs's avatar
    d_rohlfs
    2 years ago

    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.
  • olgad's avatar
    olgad
    2 years ago

    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.
olgad's avatar
olgad
Resident Rockstar
2 years ago

A dirty solution, but nonetheless:
In the filter, you choose filter type: basic, deselct everything, pick 10 entries

Then, 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

Heinrich's avatar
Heinrich
Post Partisan
2 years ago

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