1 Reply Latest reply on May 12, 2016 10:28 PM by G Marc Turner

    Restricting Filter Selection in Dashboard

    Abhay Ranjan

      Hi Folks,

      In one of our dashboards we have a multi-select filter .The requirement is such that I cannot let the end user select more than 2 values in the multi-select filter . Any pointer/suggestion on how this can be implemented? I have not explored tableau javascript but can we write javascript to achieve something similar.

       

      Please let me know.

       

      Thanks,

      Abhay

        • 1. Re: Restricting Filter Selection in Dashboard
          G Marc Turner

          Hi Abhay,

          I'm not sure if limiting the number of options selected in a multi-select filter is possible. A possible work around to this would be to create 2 parameters that allow the user to select their two choices, one choice from each parameter list. You could then use a calculated field like the following as the filter:

           

          if [Field]=[Parameter 1] or [Field]=[Parameter 2] then "Show" end

           

          I would include "none" as an option for the second parameter in case a user only wanted to select a single option. This might not be the ideal solution, but it is one that I've used before when wanting to place a limit on the number of options which can be selected.

           

          Hope this helps

          -Marc

          2 of 2 people found this helpful