Forum Discussion
Hide slicer values
Hello, I need to create a report that allows users to search by exact customer name or order ID without being able to see the list of available customer names or IDs like you normally would be able to see in slicers. Corresponding table would show "matches found" if the search produces any results or "no matches found" otherwise. Does anyone have ideas how to implement it in PBI? Thank you!
The Text slicer doesn’t have a dropdown. The user types in text, and any matching or partially matching values will be shown. This visual still is in preview you will need to enable it first.
If you need to strictly control which rows a user can see, you should use Row Level Security instead.
I ended up using a combination of text fileters and this solution https://community.fabric.microsoft.com/t5/Desktop/How-can-I-hide-data-from-populating-Visuals-until-I-filter-it-in/m-p/54807
4 Replies
Using the native Text Slicer should solve your problem !!
Not sure what you mean but slicers just show the data that's avaialble. I need that data to be hidden to users.
The Text slicer doesn’t have a dropdown. The user types in text, and any matching or partially matching values will be shown. This visual still is in preview you will need to enable it first.
If you need to strictly control which rows a user can see, you should use Row Level Security instead.
I ended up using a combination of text fileters and this solution https://community.fabric.microsoft.com/t5/Desktop/How-can-I-hide-data-from-populating-Visuals-until-I-filter-it-in/m-p/54807
