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.
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.
I think that if I display a visual with 150+ bars, it will not be well received. It needs to display all data elements in order to get gain acceptance. Thanks again for the suggestion.