Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Multi field slicer with long list of selections options

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!

 

ProductRank
Product 11
 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 21
 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
1 ACCEPTED SOLUTION

Syndicated - Outbound

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

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

View solution in original post

4 REPLIES 4
PANDAmonium
Resolver IV
Resolver IV

Syndicated - Outbound

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

Capture.PNG

avatar user
Anonymous
Not applicable

Syndicated - Outbound

Thank you, PANDAmonium.  Apologies for my delayed reply.

Syndicated - Outbound

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

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)