| Add a new Pivottable or Pivotchart and reuse the slicers of an existing PowerPivot workbook |
| Written by Kasper de Jonge |
| Friday, 19 March 2010 21:25 |
|
Lets say we have the following pivottable with slicers: now we want to add a PivotChart and have the data from the PivotChart sliced by the slicers we already have in our workbook. Add the chart as usual by clicking PivotTable -> PivotChart and add it to the existing workbook, select the data you want to see in the chart. This will give you the follwoing chart, but not sliced by the available slicers:
|
Author articles
- Help, I received a pivoted data file that I want to combine with my data in PowerPivot
- When Importing from Tabular Model use DAX
- Analyze a Twitter feed with Excel 2013, DataExplorer and GeoFlow
- NBA team spending and their results with Excel, PowerPivot and Data Explorer
- What is eating up my memory the PowerPivot / Excel edition
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?
