Forum Discussion

Bjohnson07's avatar
Bjohnson07
Frequent Visitor
5 years ago
Solved

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.

 

Any suggestions on how to accomplish this?

 

Thank you!