Excel 2013 Powerview slicer / filter entire workbook
Posted on 2014-09-09
Well, I’ve spent hours on and off trying to find an answer to this, I’m pretty sure my answer is no it can’t be done, in which case what a big fat disappointment PowerView is!
Please someone proove me wrong…
I have an Excel 2013 workbook,with several PowerView Sheets. The Sheets are based on data from several different sources, however they all have one thing in common, a ‘weeks’ field. In the data model I have all the differnet sources related together via a ‘week’ table. Every week field in each source connects to the week field in the week table.
All I want to be able to do is to be able to slice/filter ALL my PowerView Sheets in the Workbook based on what week it is this week. ( ie a selection from the week table via some sort of slicer/filter)
Is this possible??
Many thanks in advance.
PS: I am not using Excel 2013 in Sharepoint, at this moment I am just trying to evaluate PowerView/Excel 2013 funcationality before we take the plunge with sharepoint and realise that some features are different without it.