Using Multiple Filters at the same time

[Anonymous]

Hello Experts,

We have a problem where we need to filter the "From" time and "To" time and it should give the results between that time. We dont want to use the slider or the multi select option. Is there any way to create a measure or similar thing which will give the below desired result:

Table Structure:

Dataset Name	From	To
Dataset A	01:00:00	01:00:00
Dataset B	02:00:00	02:00:00
Dataset C	03:00:00	03:00:00
Dataset D	04:00:00	04:00:00
Dataset E	05:00:00	05:00:00
Dataset F	06:00:00	06:00:00
Dataset G	07:00:00	07:00:00
Dataset H	08:00:00	08:00:00
Dataset I	09:00:00	09:00:00
Dataset J	10:00:00	10:00:00
Dataset K	11:00:00	11:00:00
Dataset L	12:00:00	12:00:00
Dataset M	13:00:00	13:00:00
Dataset N	14:00:00	14:00:00

When selecting 1:00:00 in "From" and 3:00:00 in "To" slicers, it should give Dataset A, Dataset B, Dataset C.

No Idea how to attach the PBIX file here. Those willing to help, please message me, I'll provide you the sample PBIX file. 

[ERD · Accepted solution]

@Anonymous ,

I would just use a slicer with Between option if that is an option for you:

P.S.: your data example shows that From = To, so you can simply add another column in Power Query using either From, or To column.

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

[amitchandak]

@Anonymous , With independent time table check ate you getting range for time

Measure =
var _min = minx(allselected(time), time[time])
var _max = maxx(allselected(time), time[time])
return
calculate(countrows(Table), filter(Table, Table[from] <= _max && Table[to] >= Min))

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

[Anonymous]

Hello @amitchandak , we already have tried this. but it gives us blank results.