none
Excel Services - slicer in web part? RRS feed

  • Question

  • Is there a way to put a PowerPivot slicer into an Excel Services web part? 

    From what I've found, it looks like slicers aren't a named object that can be displayed, but it's difficult to tell. Is everyone really only using Excel Services in Excel Web Apps? 


    Philo Janus, MCP Bridging business & Technology: http://www.saintchad.org/ Telecommuter? http://www.homeofficesurvival.com/ Author: Pro InfoPath 2007 & Pro InfoPath 2010 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions

    Friday, June 28, 2013 1:30 PM

All replies

  • There hasn't been anything posted here, but I was wondering if you ever found an answer to this.  I could really use this functionality.
    Wednesday, January 8, 2014 9:05 PM
  • hm, not sure if i understand your issue....In my experience "Excel Web Access" Webpart doesn't care if slicer is connected to "normal" PivotTable" or a pivottable based on powerpivot, in both cases slicers are displayed and can be changed! But your Problem isn't displaying slicers in a "Excel Web Access" Webparts along with the rest of the Excel file? 

    You wan't to have two Webparts? One which Displays the Excel file Content (including slicers) and another "filter Webpart" which is connected to first Webpart and controls value of slicers selected? Then there seems to be still a issue in Excel REST API which blocks Setting of slicer values, see also this post:

    http://social.technet.microsoft.com/Forums/sharepoint/en-US/b267d067-13fc-4a92-8688-a5054fbb8e6c/excel-services-api-how-to-change-slicer-or-pivotfilter-values-via-url

    Thursday, January 9, 2014 10:22 PM
  • JJ, thanks for your reply.  When I save a Pivot Chart in Excel and point the Excel web part directly to the named object it displays the chart correctly, but it does not display the slicer. Even if I lay the slicer over the top of the chart area. I don't need to set the slicer value with code as the page loads or anything, I just need it to show.

    It works fine if I don't use a named item and just display the whole sheet.

    Wednesday, January 15, 2014 1:43 PM
  • >When I save a Pivot Chart in Excel and point the Excel web part directly to the named object it displays the chart correctly, but it does not display the slicer.

    Ok understand. Yes,this is the expected behaviour, you reference the Chart by Name and not the slicer(s) which is another named object (but you cant reference in Webpart ;)

    How about defining a "print area" which includes Chart + relevant slicers...and then reference in Webpart this named object "PrintArea" (check ribbon>formuals>"Name Manager" for correct naming). Does this work?

    • Proposed as answer by TresL Monday, June 30, 2014 3:02 PM
    Wednesday, January 15, 2014 2:47 PM
  • It doesn't matter - we can make it "work" by simply using the sheet. This was a huge missed opportunity by not enabling slicers for web parts - to be able to have a slicer web part that could interact with not just Excel Services charts and graphs, but other data would've been very awesome. 

    And since 2013 is established I know we'll never see it change. Pity. It ruins a whole slew of scenarios for me. 


    Philo Janus, MCP Bridging business & Technology: http://www.saintchad.org/ Telecommuter? http://www.homeofficesurvival.com/ Author: Pro InfoPath 2007 & Pro InfoPath 2010 Pro PerformancePoint 2007 Pro SQL Server Analysis Services 2008 Building Integrated Business Intelligence Solutions

    Wednesday, January 15, 2014 3:36 PM
  • JJ78 you are my hero - the print-area idea works wonderfully! I'd been looking for a way to just display my PivotCharts and slicers in a "clean" view (without the Excel row and column headers, or the unappealing necessity of hiding gridlines and moving the supporting PivotTables to way down on the page). The slicers are visible and work, and overall it is a much cleaner look to a Web part to NOT to be so Excel-like!

    Note for anyone else using JJ's elegant solution who may not be as familiar with print areas in Excel:

    1. In Excel, select the worksheet area you want to display (for me , this was the cells containing/around two PivotCharts and two slicers)

    2. In the Ribbon, select the Page Layout tab

    3. Click on Print Area - Set Print Area

    4. In the Ribbon, select the Formulas tab

    5. Beside the Name Manager (which as JJ says is where you can check the defined names within the workbook, to prevent conflicts) , click Define Name

    6. Type in a name (like "PrintArea") - you will see your selected cell range in this dialog

    7. Click OK

    Thanks again JJ!

    cheers /td




    • Edited by TresL Monday, June 30, 2014 3:03 PM
    Monday, June 30, 2014 3:00 PM
  • I have successfully used Slicers in Excel Web Parts - they work great. @TresL note that the first 3 steps above are redundant. You just need to define a name, and then refer to that name in the Excel Web Part.

    That said, what was working for me last week has stopped for some reason so now the slicers are not displaying alongside the pivot charts. Debugging that now so that's why I ended up here. :-)

    Tuesday, October 21, 2014 11:13 PM
  • We are experiencing same issue in our Office 365 environment and Excel 2013, slicers were being displayed properly on webpart using defined ranges and they suddenly disappeared.

    We have not touched the base workbook or webpart configuration.

    Any solution hint?

    Friday, October 24, 2014 1:58 PM
  • Hi,

    I managed to make this work. Well sort off. The issue is that when defining the print area, if the pivot table I crated spans across the defined area (e.g. when expanding hierarchies) then it will not show.

    There must be a better way to achieve this?

    Regards,

    P.

    Tuesday, December 23, 2014 2:24 PM
  • Hi All,

    Did any one found the solution! I tried with the solution said in this forum but the slicer are displayed like image and also i cant able to send or receive filter value also.

    I displayed Slicer with defined name using EWA web part and displayed pivot data in another EWA webpart.

    how we can have the slicer type filter in SharePoint 2010 Excel service?

    Thanks in advance!!!


    Vijaivel

    Wednesday, June 24, 2015 10:39 AM