Visual level filter with DAX

[katto16]

I have this data table visual with serial number column that consists of serial IDs as well as blanks, 0s and "ref", "REF". I want to take them out and only leave the table with actual serial numbers. Is there any way I can set a visual level filter with DAX? I do not want to filter them out in Power Query as I still want to see the original test record if it's needed.

In the visual filter pane, I can only set max of two filters but I need 5 filters.

Show items

<> ""

<> 0

doesn't contain "REF"

doesn't contain "ref"

doesn't contain "Ref"

Any help is appreciated. Thanks in advance!

[johnyip · Accepted solution]

@katto16 You can try changing the filter type to basic filtering first, and then select all the unneeded values from the list. And finally, change the filter type back to advanced filtering, and make some other appropriate changes.

[johnyip]

A further tips, if you want to filter <> "", maybe you can select an additional random item from the list of basic filtering, after that when you have switched to advanced filtering, alter that random selection to "is not blank" or "is not empty" in the show items when value is option.

Depending on your data, I think you may select only one of them, or actually both. If you need both, apply the above steps with two random selections.