Forum Discussion

katto16's avatar
katto16
Helper I
3 years ago
Solved

Visual level filter with DAX

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!

 

Need Help
  • johnyip's avatar
    johnyip
    3 years ago

    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.

2 Replies

  • johnyip's avatar
    johnyip
    Solution Sage
    3 years ago

    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's avatar
      johnyip
      Solution Sage
      3 years ago

      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.