Forum Discussion

dgilm33's avatar
dgilm33
Icon for Helper I rankHelper I
3 years ago
Solved

Setting limits to the values users can enter into a slicer

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?

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    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.

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    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.