cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ibrahimsharaf Frequent Visitor
Frequent Visitor

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 those empty values from the slicer (as in the screenshot), maybe using a measure?, any help?

Screenshot (13).png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: How to exclude some values from a slicer?

@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. Smiley Sad

Near SE WI? Join our PUG Milwaukee Brew City PUG
2 REPLIES 2
Super User
Super User

Re: How to exclude some values from a slicer?

@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. Smiley Sad

Near SE WI? Join our PUG Milwaukee Brew City PUG
v-haibl-msft Super Contributor
Super Contributor

Re: How to exclude some values from a slicer?