Solved

Excel 2013 Powerview slicer / filter entire workbook

Posted on 2014-09-09
2
657 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
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 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

8 Experts available now in Live!

Get 1:1 Help Now