Forum Discussion
Cannot view all items within a Filter.
We have 156 facilities. When trying to filter by one or more facility, Power BI only displays a portion of the facilities. Being able to select individual or multiple facilities is critical to gaining insight into our business. Is this a limitation of the tool, a bug, and/or are there plans to remove this restriction? Thanks.
8 Replies
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.
