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
Solved

Excel 2013 Powerview slicer / filter entire workbook

Posted on 2014-09-09
2
692 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
2 Comments
 
LVL 3

Accepted Solution

by:
prequel_server earned 500 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

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…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

856 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