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.
Are you talking about adding a "Report Filter" to your Pivot table?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?