Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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. 😞
Just wanted to add to this that the workaround works again! You can change it to a table and select which ones and then change it back to a slicer.
@Anonymous - they added in the functionality directly to the slicer now. You don't need to switch from table to slicer, you can just add a filter to a slicer like all the other visuals.
As Eno1978 said, the workaround does not work after the June update. You can vote the idea in below links.
Best Regards,
Herbert
@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. 😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |