Hi
Seeking help to remove 'Blank' slicer fields in excel. I have a dashboard style report with slicers linked to multiple data sets. My slicers are generating a 'blank' button in both slicers. I have checked my table ranges in both data sets to ensure no blank fields. Most of my pivot tables are displaying a 'blank' data filter which I presume is cause of my issue however I do not understand why? I have not been able to resolve this issue via the Slicer Settings > Hide items with no data. Help appreciated! My pivot tables and slicers can be located on the ANALYSISDATAMODEL tab.
File attached.
Bookmarks