Is there a way to allow the user to select the min and max of a value

[bryanshaw46]

I have a table of invoice totals and I would like for the users to be able to pick a values range for them.  For instance, I only want to see invoices 1 million and above, or any invoice that is below zero.

[Greg_Deckler · Accepted solution]

Lots of different ways of doing this, here are a couple.

1. Add the invoice amount to the filters area and teach the users how to use filters.

2. Add a calculated column that creates "buckets" that you care about, such as:

IF([InvoiceAmount]>1000000,"> 1 million",IF([InvoiceAmount]<0,"Negative","Meh"))

Now you have a column you can create a slicer on that would have the values:

> 1 million

Meh

Negative