I have created a Dashboard with Excel 365 (V 16.0.11601) using data from an SQL Server, via Power Query and Pivots / Charts. The Pivots and Charts are linked with data slicers in order to filter data.
The idea is, that the user does not need to connect to the SQL Server but uses directly the data from Power Pivot. With my Excel versions the slicers work as expected.
Customers which are using Office 2016 Professional Plus (V 16.0.4738) complained, that the slicers and pivot-filters do not work.
We were able to reproduce the issue with Excel 2016: If we click on a slicer element or select a filter-value in a pivot-table, excel is shortly "calculating" but then the filter / slicer gets reset and the data is not filtered or refreshed. No error is shown.
Anyone has an idea, what's the reason of this behaviour?