Filter Dataset on a selected value which comes from a min/max range
Hi there - I am learning the PowerBI platform and can figure out how to mostly get what I need done accomplished, but I have not found the answer to this question yet.
I have a set of data such as this:
Location I MinSize I MaxSize
Rm 1 2 7
Rm 2 1 5
Rm 3 7 10
Rm 4 8 13
Rm 5 1 13
There are set sizes that someone could select that falls within those ranges. What I need is a way to filter that data with a selectable slicer for the size numbers. So if I was to select the number "3" on the slicer, only Rooms 1,2 and 5 data shows, if I select "6" then rooms 1 and 5 data shows. The way it is connected is through room numbers to my other tables.
I would be okay having a list with the individual sizes show up to select from or a range slicer (other options?) - as long as the data filters for anything between the two range values and is easy for the end user to select.