Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Slicer issue

Copper Contributor

I have a main pivot table with 4 slicers and one of the slicers is no longer pulling through one value. For example the column is filled with people's names (where you can only select set names), approximately 50 different names. The slicer no longer brings through one of the names, just has 3 dots showing and on the pivot table it is completely blank. The other linked data appears to be correct but no name showing. I've been through the whole base data to review for any obvious data entry issues and resolved them where I have observed them but this has not helped. This spreadsheet does have broad access for data entry, currently stored in SharePoint.

Any ideas to assist would be greatly appreciated :)


Updated to add a visual!

0 Replies