Slicer Design/Function Recommendation

[Anonymous]

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".

[Vvelarde]

@Anonymous

Hi, try using Smart Filter by OkViz

https://store.office.com/en-us/app.aspx?assetid=WA104380859&sourcecorrid=217f5cac-0517-4ff0-b1d9-5a9ba8457569&searchapppos=81&ui=en-US&rs=en-US&ad=US&appredirect=false

[Anonymous]

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?

[v-sihou-msft]

@Anonymous

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,

[Anonymous]

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!

[sokg]

Do you harvest this selection and use it in a calculation????

[Anonymous]

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.

[sokg]

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.