Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Advance Filtering not removing (blank)

Howdy Everyone!

 

I have been browsing the forums trying to find out how to remove (blank) from my slicer in PowerBI. However, no matter what I filterby that pesky (blank) will not go away. I have tried to apply the filter on both the "Filters on this page" and "Filters on this visual" to no luck. Any ideas would be greatly appreciated thanks!

  • Anonymous's avatar
    Anonymous
    3 years ago

    So there are no blank rows within our data, however we did figure out the solution. We needed ended up swapping the slicer from a drop down to a list, then exluding it. Once we swapped back the (blank) was gone, thanks for the Input though!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      So there are no blank rows within our data, however we did figure out the solution. We needed ended up swapping the slicer from a drop down to a list, then exluding it. Once we swapped back the (blank) was gone, thanks for the Input though!

      • Anonymous's avatar
        Anonymous
        Not applicable

        This appears to be due to a bug within PowerBI, as I am able to apply pervious solutions when I do the list/drop down toggle.