Solved

Excel 2013 Powerview slicer / filter entire workbook

Posted on 2014-09-09
2
667 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 2016 Excel Issue 4 26
Split a string in excel 9 30
Excel 2010 - Comparison of texts in a cell 14 29
Problem with Excel and File Size 7 16
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now