Repository navigation
Add PivotChart Slicer setting: "Hide items with no data" #2464
Description
Is your feature request related to a problem? Please describe.
In Excel, I can enable the "Hide items with no data" setting on a Slicer: 
But I don't see that EP-Plus supports that. I do see a eCrossFilter which has an enumeration of None, ShowItemsWithDataAtTop, ShowItemsWithNoData, but I think that maps to "Visually indicate items with no data" and "Show items with no data last", although I could be wrong.
Describe the solution you'd like
Have EP-Plus support the "Hide items with no data" setting on a Slicer.
Activity
OssianEPPlus commentedon Aug 17, 2026
Good Catch! We've looked into this, looks like we Do have this option but only for TableSlicers rather than _Pivot_TableSlicers.
Available via
Slicer.Cache.HideItemsWithNoDataI've made a PR to move this option to the base class so that it becomes available for Pivot Table Slicers as well
Fixed #2464 (#2467)
OssianEPPlus commentedon Aug 20, 2026
Fixed with the release of Epplus 8.7.0
Feature/drawing renderer refactor (#2480)