The “Slicers Vertical”pane in the PowerPivot Field List: A Row/Column Filter will show these in a tree structure, whereas a slicer will split them up into separate (but related) slicers.Ī PivotTable that is associated to a PowerPivot data source has two additional Slicers panes available that the standard Excel PivotTable doesn’t have. The user interaction needs to be a hierarchical tree (ex: Country > State > City).Whereas slicers take up quite a bit of space, Row/Column filters are embedded within the PivotTable itself. (Slicers and Report Filters work filter on attributes only.) You need Top 10, Label Filters, or Value Filters which are part of traditional PivotTable filters.A Report Filter will show these in a tree structure, whereas a slicer will split them up into separate (but related) slicers.Ī traditional Row/Column Filter may be the best choice if: You have more than 4 or 5 different fields to filter on.Your user base is familiar with standard PivotTable functionality.Whereas slicers take up quite a bit of space, Report Filters show their selections via a compact drop-down menu. You only have 2-4 different fields to filter on (more than that can just take up so much space).Ī traditional Report Filter may be better if:.Flexibility for placement, sizing, or formatting of the slicer is of importance.Seeing the items currently selected directly on the worksheet is helpful (i.e., the current state of the filter), as opposed to “Multiple Items” in the Report Filter, or just a small icon which can easily be overlooked.The ability to slice & dice by the same field is not allowed by the Report Filter. You want to display the same field in the slicer as well as on the columns or rows.Since traditional filters are associated with one PivotTable only, slicers really have the potential to make Excel dashboard far more functional. You want to control filtering of > 1 PivotTable with one click.Slicers can be used in conjunction with standard PivotTable filter functionality (i.e., the Report Filter, Column, and Row Filters). Technically, this is not an either/or decision. Choosing Between Slicers & Traditional PivotTable Filters
In the Book Sales Dashboard screen shot shown above, I placed the PivotTables which support the two charts on a hidden worksheet. If you are displaying (and slicing on) a PivotChart, there must be a PivotTable “underneath” the PivotChart. > Hint! Using PowerPivot to mashup, or consolidate, your data from different sources can be of real benefit. There’s a catch though: the multiple PivotTables must use the same underlying data connection. Slicers are extremely useful if you create a dashboard page and you want one click to affect multiple items on the page. Easy (And Even Fun!) Data Exploration: Introducing Excel 2010 Slicers, andĬonnecting Slicers to One or More PivotTablesĬonnecting a slicer to more than one Table is the greatest benefit of slicers & what makes them better than traditional PivotTable filters (i.e., the Report Filter and the Row/Column Filters).If you’re not familiar with slicers, take a quick look at the following before reading on: The above screen shot uses publicly available data I originally downloaded from the UK Guardian Data Store. What is a Slicer in Excel 2010?Įxcel 2010 introduces slicers as an alternative to traditional PivotTable filters (i.e., the Report Filter and the Row/Column Filters).įollowing is an example of how slicers are presented in Excel: For instance, if we have a PivotTable showing Internet Sales for 20 by Country and by State, then we have sliced the data by year and diced it by geography. Dicing the data refers to selecting which attributes we’re grouping the data by. The Slicing part refers to filtering your data to focus on just a subset – essentially the “where” statement. The phrase “slice and dice” is used a lot when referring to the analysis of data. Level: Basic understanding of an Excel PivotTable is helpful. Overview: This blog entry discusses using slicers within Excel 2010 to filter the data being presented, with an emphasis on choosing between traditional filters & slicers.
0 kommentar(er)
