Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
I think if you leave to filter pane that would be better. Filter in filter pane has more options.
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
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
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'.
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.
Does this clear things up?
I think if you leave to filter pane that would be better. Filter in filter pane has more options.
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |