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...
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.

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.