Forum

Power Query and Sli...
 
Notifications
Clear all

Power Query and Slicers

4 Posts
2 Users
0 Reactions
150 Views
(@deb3733)
Posts: 6
Active Member
Topic starter
 

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?Cry

 
Posted : 29/08/2018 9:41 am
(@deb3733)
Posts: 6
Active Member
Topic starter
 

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. Laugh

 
Posted : 29/08/2018 10:19 am
(@mynda)
Posts: 4761
Member Admin
 

🙂 it's always most rewarding when you figure things out yourself. Well done!

 
Posted : 30/08/2018 9:11 pm
(@deb3733)
Posts: 6
Active Member
Topic starter
 

Thank you! WinkYes it is!!!

 
Posted : 01/09/2018 8:39 am
Share: