cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bjohnson07
New Member

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!

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@Bjohnson07 

Please check the attached file below my signature 

Fowmy_0-1627586404537.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@Bjohnson07 

Please check the attached file below my signature 

Fowmy_0-1627586404537.png

 



Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Kudoed Authors