I have an Excel document where I have connected to another document through Power Query called CCList. There is another document within the workbook called OT where I have vLookups to the document connected through Power Query - CCList. I have a pivot table created from the OT document and one of the slicers is created duplicates within the slicer. Within the slicer settings I have chosen "hide items with no data" thinking that might help but I continue to have the duplicates. Any ideas why this might be happening?
Well...I guess it just took me posting here to figure it out myself. I had to do a trim and clean on the column and that resolved my issue.
🙂 it's always most rewarding when you figure things out yourself. Well done!
Thank you! Yes it is!!!