Excel services - how to add a report filter ? RRS feed

  • Question

  • I am I am publishing a power pivot workbook to SharePoint 2013 in order to let users interact with it by means of Excel services. I am trying to specify a global filter for the report in the the dedicated Excel services menu that is displayed on the left-hand side of the screen.But without any success so far.

    When saving the workbook, I have selected the browser view options "show items in the workbook" and selected a couple of named ranges. In the "parameters" tab of the browser view options dialogue, I have selected one of the slicers which were available in the list of items to select.I can select nothing else but slicers, so I was hopeful that the slicer would show up in the filter menu. 

    Could anyone provide details on how to use this parameters feature when publishing to SharePoint ? How can I have this menu populated with dates that user can select to filter the whole report ?

    Monday, June 13, 2016 5:18 PM


  • This may help you.


    Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

    Sunday, January 1, 2017 6:19 AM

All replies