Multi field slicer with long list of selections options

[Anonymous]

I'm generating a table that calculates an estimated commission for each sales rep (who's 1 of approx 30 sales reps on the sales team)

The sales reps estimated commission, per product (of which there are 5) is driven off of how their total sales (per quarter) rank in comparison to total sales of all the other reps.

I created a slicer that has two fields: Product and Rank:  all of the following appears in one slicer... where, for each product... the sales reps enters what they think their rank will be by the end of the quarter; so they can do a what-if analysis.  Since, for each of the 5 products, the sales rep has to select a rank of 1-30, the slicer expands and become very long.  Does anyone have any idea or suggestion they can share on how a slicer can accomplish the same thing- allowing the user to select a rank for each of the 5 products- that is a better user experience?   Thanks!

Product	Rank
Product 1	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30

Product 2	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
	13
	14
	15
	16
	17
	18
	19
	20
	21
	22
	23
	24
	25
	26
	27
	28
	29
	30

[PANDAmonium]

You could go with two horizontal slicers with single select on. It's probably a lot faster and cleaner considering your use case.

[Anonymous]

Thank you, PANDAmonium.  Apologies for my delayed reply.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Do you need any other help on this thread? If not, could you please mark your post as answered? Thank you.

Best Regards

[Anonymous]

Thanks for letting me know to do that.  I have accepted it as solution now.