Forum Discussion

ibrahimsharaf's avatar
ibrahimsharaf
Microsoft Employee
10 years ago
Solved

How to exclude some values from a slicer?

Hello, I am using a slicer with takes a column of strings, some values in this colomn don't contain a value, I don't want to delete these records as its row has another useful data, how can I exclude...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    10 years ago

    ibrahimsharaf Oh man, this one is a sore point with me. "Before" the June update, all you had to do was change the visual to a table and filter out any of the values, then change it back to a slicer and the filter would be respected. For some reason (unknown to me) they removed this work around and haven't yet provided a filter option for the slicer.

    At this point, I don't see a way to do this simply. :(

Anonymous's avatar
Anonymous
Not applicable
10 years ago

ibrahimsharaf Oh man, this one is a sore point with me. "Before" the June update, all you had to do was change the visual to a table and filter out any of the values, then change it back to a slicer and the filter would be respected. For some reason (unknown to me) they removed this work around and haven't yet provided a filter option for the slicer.

At this point, I don't see a way to do this simply. :(