Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel 2013 Powerview slicer / filter entire workbook

Posted on 2014-09-09
2
Medium Priority
?
805 Views
Last Modified: 2014-09-16
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??

HELP!

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.
0
Comment
Question by:deborahhowson00
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
prequel_server earned 2000 total points
ID: 40324421
I don't think this is possible. PowerView sheets are isolated little buggers. Multiple charts within the same PV sheet can be filtered concurrently but not across multiple PV sheets.

Also native excel controls like Slicers cannot be linked to PV sheets. PV Sheets have their own controls in Silverlight.

If you wanted to create multiple dashboards in different sheets and have them all get filtered using a common date slicer, you would have to use the native excel charts, if using PP model then you would insert pivot tables and pivot charts from the  PP model.

hope this helps
0
 

Author Comment

by:deborahhowson00
ID: 40324870
OK thanks, I thought that was the case, seemed to have exhausted all the different options and come to the same conclusion.  Many thanks for confirming.
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question