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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors