Slicer to select the top values

[raassd]

 Hi Team,

I want to give the user a slicer where he can select the number from top 1 to n values and my visual should show only those results.

Please help me.

Here is my data

Names	Ranks
A	1
B	2
C	3
D	4
E	5
F	6
G	7
H	8
I	9
J	10
K	11
L	12
A	13
B	14
C	15
D	16
E	17
F	18
G	19
H	20
I	21
J	22
K	23
L	24
Y	25
Z	26

[v-jianboli-msft · Accepted solution]

Hi @raassd ,

You can change the format of Slicer to List:

Output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@raassd , Refer this solution

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...