cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Best filter option for numbers

I need a filter that will allow end users to enter a number that can then be used in a measure. My problem is that the range is very large so scrolling through or simply displaying all values isn't really an option. Is there a filter or setting where I can have the user simply type in the number then enter? 

1 ACCEPTED SOLUTION

I think if you leave to filter pane that would be better. Filter in filter pane hasScreenshot 2019-09-26 20.53.22.png more options.

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

5 REPLIES 5
Super User I
Super User I

Hi @GunnerJ ,

 

 Good question.  Change your cursor type to one of the three circled below using the down arrow location marked with my arrow. Then you will have 1 or 2 boxes that the user can fill in.  If their input is outside the range, it will revert to the closest possibility.

 

Please let me know if you have any questions.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Filter.PNG

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@Nathaniel_C  the problem is that I need the selection to be a single number and not a range of values. 

Hi @GunnerJ ,

If I understand your issue, use the less than or equal to or greater than or equal to. There is only one box to fill in. If you can perhaps post a picture of your filter.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@Nathaniel_C  If I use a range filter my calculation doesn't work. The visual with an error is just looking at the selected value. Currently the value is actually "valueS" 0-10 instead of just '10'. 

Number Filter.PNG

 

Below I have a dropdown which functions but isn't practical since I have a very very large range. If I could just type in the value I want then the dropdown would be fine.

Number filterd dropdown.PNG

 

Does this clear things up?

I think if you leave to filter pane that would be better. Filter in filter pane hasScreenshot 2019-09-26 20.53.22.png more options.

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors