Hello! When I select Slicer settings I do not have the 'Use Custom Lists' when sorting option. I am working with Excel 2013. Any idea why this would not be an option in my Slicer Settings window?
Hi Diana,
That's odd. I have Excel 2013 and the option is there. Are you able to share the workbook?
Mynda
Has this been addressed?
I have exactly the same problem!
More information: I have in my workbook 2 datasources. The slicers connecting to pivot tables of one datasource (just a table) - do have the 'Use Custom Lists' checkbox option!
However, the slicers connected to pivot tables of the other datasource (OLAP - data model) - do not have this option!
Is that thus a limitation of using OLAP / data model?
Any workaround? This is hugely annoying!
Just found a reference to that:
Seems indeed that this option is only available for non-OLAP
Hi Michlus,
If you load your data into the Data Model you can add a column to your table and use 'Sort by' on the Home tab of the Power Pivot window to specify the sort order.
Mynda
