How to add a drop down in the powerpivot excel report?

Question

Hi,

I am trying to create a report in that data is accessed from poverpivot model uploaded in SharePoint. I want to add a dropdown on location for filtering.

Answer 1

Are you talking about adding a "Report Filter" to your Pivot table?