Slicer for a warehouse location - From (choose location) to (choose location)

[Birdie]

I am trying to do a simple cycle count program for our inventory department that they want to go count by location. Locations are in alphabetical order (C1,C2,C3... etc) . To do that, ideally, they would choose a "Start Location" and an "End Location" as slicers, then the data shown to go count would be between those two locations via a standard Power BI table with part number, location, quantity. Example - we want to go count all locations between C12 and D16 today. 

One way I gotten it to work, but it isn't very user friendly, is having a slicer for the location that shows all locations, and the user could click each box and hold ctrl down for every box until they are to where they want to stop. I want a from and to, like dates are on slicers. Is that possible?

thanks!

[v-eachen-msft · Accepted solution]

Hi @Birdie ,

You could add a number column to achieve this result.

Here is my sample data.

Then use ALLSELECTED(), MIN() and MAX() functions to get the range.

Here is my test file for your reference.

[Birdie]

I think that may work, thank you!

[v-eachen-msft]

Hi @Birdie ,

You are welcome.

[rajulshah]

Hello @Birdie,

You can create two columns, Start Location and End Location > Have slicers for both of these columns and then create a measure to count cycles between Start & End Location. If you can provide sample data, I can help you in a better way.