Answered by:
Excel services - how to add a report filter ?

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
Answers
-
This may help you.
https://support.office.com/en-us/article/Use-a-report-filter-in-a-PivotTable-or-PivotChart-report-f529b739-9f59-4d16-8a69-666273140d90
Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, January 3, 2017 11:54 PM
- Marked as answer by Michael Amadi Tuesday, January 31, 2017 11:20 PM
Sunday, January 1, 2017 6:19 AMAnswerer
All replies
-
Bertrand, any luck with this?
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!Friday, July 29, 2016 8:25 PM -
No. I did not find any documentation on how to use this feature.Monday, August 1, 2016 9:11 AM
-
Does anybody have a suggestion for Bertrand?
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!Sunday, October 30, 2016 10:17 AM -
Bertrand, any update on this issue?
You can send a Frown to the Power Pivot team if you run into any more troubles. Thanks!
Thanks!
Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)
Answer an interesting question? Create a wiki article about it!- Edited by Ed Price - MSFTMicrosoft employee Friday, December 16, 2016 5:19 AM
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, January 3, 2017 11:54 PM
Friday, December 16, 2016 5:19 AM -
This may help you.
https://support.office.com/en-us/article/Use-a-report-filter-in-a-PivotTable-or-PivotChart-report-f529b739-9f59-4d16-8a69-666273140d90
Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.
- Proposed as answer by Ed Price - MSFTMicrosoft employee Tuesday, January 3, 2017 11:54 PM
- Marked as answer by Michael Amadi Tuesday, January 31, 2017 11:20 PM
Sunday, January 1, 2017 6:19 AMAnswerer