Allow us to filter slicers
I use Excel for connecting to tabular data models to create pivot tables with slicers. Our clients do not want to see blank slicer buttons or slicer options that are no longer valid (ie, a medical office location closed several years ago, but that data is still in our database to maintain historical scores). I have seen in PowerView that we can filter the slicer options to only display the ones you want. Would be great to have this in the desktop version of Excel. Thanks!
Kenneth Barber commented
In your case, you should retrieve the data using Power Query (Get & Transform). In Power Query, you can specify what data you do or don't want. Then load the Power Query table into the Data Model.