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.
Heinrich's avatar
Heinrich
Post Partisan
2 years ago

Hi olgad 

Thank you very much.

Have a great weekend.

Regards

Heinrich

olgad's avatar
olgad
Resident Rockstar
2 years ago

Please Heinrich dont forget to accept the solution that helped you solve the problem. Thanks, have a greate one too.