Forum

Slicer to act on th...
 
Notifications
Clear all

Slicer to act on the N choice of Top N filter available in Value filters

2 Posts
2 Users
0 Reactions
72 Views
(@peterwarburton)
Posts: 17
Eminent Member
Topic starter
 

Is there any way to make a slicer that chooses the N in a Top N value filter in an Excel  PowerPivot chart (without writing VB code)?

I.E I want the dashboard user to be able to ask for, say, the top 10, 20, 25 or 50 resellers' sales.

 

Peter Warburton

 
Posted : 23/11/2021 3:36 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Peter, 

You can use a disconnected Slicer to do this. See example file attached.

Mynda

 
Posted : 23/11/2021 9:14 pm
Share: