[Help] Slicer "in between" with integers with 2 different columns

[HappyToadin]

Hello,

I have 2 columns with integers (Let's call them Start and End) which values go from 300 to 2700

I want to create a slicer that allows my user to select data in between Start and End and that let's him input the Start value he wants and the End value he wants.

checkboxes are simply not user friendly is this case.
He should only need to tape in a box the number for start he wants and the number for end he wants

[v-yohua-msft]

Hi, @HappyToadin 

Thanks Ibendlin for the workaround, here are some of my additions to this. You can create a table with all the integers in this range, with values between 300 and 2700. Then put it in the slicer.

IntegerTable = GENERATESERIES(300, 2700, 1)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

[Phoenix45]

I am sorry but any of these responses are about generating an unrelated table that i don't see how it would filter any of the data i want (no relationship with my dataset).

I need Start and End as they are associated with other columns in my dataset. They are not random values.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[HappyToadin]

StartRange	EndRange	Number of Items
300	315	345
315	330	3432
330	345	34235
345	400	545454
400	500	4545454
500	700	43545433
600	900	342342342
800	1400	534324325
1500	1700	5435565643
2200	2500	9895454431
2600	2615	19895454431
2615	2630	39895454431
2630	2645	59895454431
2645	2700	79895454431

Here's a simplified example of the dataset. Start range starts at 300 and ends at 2645, end range starts at 315 and ends at 2700. 

With a single slicer the user needs to be able to select all the data in between the value selected for start and the value for end

[lbendlin]

Now I am totally lost.  I cannot imagine how the UX is going on here. Surely there must be an easier way for your users to navigate the data?

[Phoenix45]

[Phoenix45]

I simply want a single slider slicer not 2. The user choses the start date and the end date and he gets the data in between

[lbendlin]

Use a single slicer.  In your measure query the MIN and MAX values of that column. use thes against your Start and End dates.

[lbendlin]

Use GENERATESERIES(300,2700)  and feed a single range slicer from this.

[Phoenix45]

But how would the slicer filter the data with generateseries ?

Start and End are columns and there are other columns in the dataset that need to be filtered according to start and end.

[lbendlin]

You don't need Start and End columns.  Use MIN(Slicer[Value]) and MAX(Slicer[Value]) to read the user input.