Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Bjohnson07
Frequent Visitor

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors