Beginner with powerquery sorry!
I'm trying to access trade data in a workbook where a slicer is filtering according to exports/imports etc.
The result is that I can only access the 'default' set through powerquery, and cannot navigate between the different slices, nor see the whole set of underlying data.
I have found a workaround by just saving a copy of the workbook and copying out each 'slice' to a new sheet one by one. I am hoping that there is a better solution though that I can implement before the data next updates and I am forced to do the same again!
Thanks
发布者:admin,转转请注明出处:http://www.yc00.com/questions/1745062133a4609028.html
评论列表(0条)