Cannot view all items within a Filter.

[jdt008]

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.

[Greg_Deckler]

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.

[jdt008]

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

[jdt008]

...(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. 

[Greg_Deckler]

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.

[jdt008]

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.

[Greg_Deckler]

Understood.

I was suggesting using the bar chart in place of a slicer as it will do the same thing. Tree maps, pie charts and donut charts along with bar and column charts all work like splicers. The bar chart includes a scroll bar to scroll through all elements.

[jdt008]

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.