Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I currently am using a slicer to allow users to select a "Budget" and impact the results of the dashboard.
The challenge I am having is that the budget amount is in $1.00 increments, and the amount of options does not allow me to use the ""Search" function in the slicer.
Looking for suggestion show I may be able to make the slicer (or other option) accessible to data entry by the user...or a preferred way of allowing a user to select a "budget amount".
Hi, try using Smart Filter by OkViz
Thanks @Vvelarde
This can have some great application but in the case of my dataset where I have the budget listed in increments one dollar, I am only having onve value returned in this solution.
Any other ideas?
What's the data type of your "budget" field?
If the budget field is numeric, you should be able to select "Between" instead of "List" in slicer so that you can select a data range.
Regards,
This is an okay option.
To make it slightly more complicated, I am usins the slicer to output results in a tile. So for the "between function" to work, each of the two fields need to be the same.
See creen capture below.
Any additional suggestions would be great!
Do you harvest this selection and use it in a calculation????
No, it's a straight list in the table as a column. If there is a better way of doing it - I am all ears, but will likely need some detailed instruction.
Thanks.
I was thinking that you must use buckets.
Somethink like 1031-1040
1041 -1050
1051-1060
To do this you must create a column BucketsBudget = CEILING(TABLE[Budge],10) where 10 is the range and you can change it.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |