Forum Discussion
Cannot view all items within a Filter.
You can use Advanced filtering to allow you to select any value (if you know the name, use Contains). Also, instead of using a filter, try using a slicer, it will list all of the values.
Thank you, my friend. I'm aware of this. However, I have many consumers of this data who have busy day jobs, and to ask them to keep another list outside of the tool (where they have to reference and manually type multiple facility names into the advanced filter), will only serve to lose adoption of the tool. We had the ability to view all data elements in a Filter when we were using Power View, and from the consumers' perspective, this established the expectation. Hopefully, this will get rectified in PBI. Thanks for taking the time to try to help me out. Much appreciated.
Tried the Slicer, however the Slicer is not behaving well at the moment. When you scroll down, not only does the slicer move with the mouse, when you try to select the 100th data element, for example, it auto scrolls back to the top of the Slicer, and when
...(continued) and when you scroll back down the Slicer, the selection was not made. I'm assuming there is a restriction when you exceed a certain number of data elements within the slicer.
What about trying a bar chart? You could pick your Facility and then just have any number like 1. Then, when users click the bar for the facility, it will filter the tables on the view. I realize this is a weird interface but the bar chart will list all of the values you have and I have not seen the same annoying behavior as with slicers.
