Setting limits to the values users can enter into a slicer

[dgilm33]

Hi, I have a slicer and detail table on my page. The detail table shows every purchase made and the savings and savings % that could have been had. The slicer is using the savings % column so the user can enter and see where savings were 30% or greater for example. I want to set limits around what the user can enter into this slicer. I do not want them to be able to enter a negative, or anything above 100%. I know I can do this when using a measure, but I do not want to sum the savings % because then it doesn't filter the table correctly. Is there a way I can do this using a column and not a measure?

[v-zhangti · Accepted solution]

Hi, @dgilm33 

Yes, you can create a calculated column in your table that will limit the values that can be selected in your slicer.

Here's an example formula that you can use: 

Savings % Limit = IF(AND([Savings %] >= 0, [Savings %] <= 1), [Savings %], BLANK())

This formula checks if the value in the Savings % column is between 0 and 1 (which is the same as 0% and 100%). If it is, then it returns the value in the Savings % column. If it's not, then it returns a blank value. You can then use the Savings % Limit column in your slicer instead of the Savings % column to limit the values that can be selected.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.