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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors