excel - Powerquery not able to access data behind slicer - Stack Overflow

Beginner with powerquery sorry!I'm trying to access trade data in a workbook where a slicer is fi

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

相关推荐

  • excel - Powerquery not able to access data behind slicer - Stack Overflow

    Beginner with powerquery sorry!I'm trying to access trade data in a workbook where a slicer is fi

    17小时前
    10

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信