3 Replies Latest reply on Oct 5, 2017 2:00 AM by REDDY SEKHAR

    Dynamically change row dimensions based on filter (multiple selections)

    Jennifer Cohen

      I have a multi-select filter set up on a dashboard.  I would like to have the filter results drive the row dimensions shown in the table on a one-to-one basis.

       

      So if my multi-select filter has items:

      Endpoint 1

      Endpoint 2

      Endpoint 3

       

      And with check boxes next to each one....

       

      How do I tell Tableau to only show the row dimension "Endpoint Results 1" if Endpoint 1 is selected, etc...

       

      Thanks!!!

        • 1. Re: Dynamically change row dimensions based on filter (multiple selections)
          Tableau kumar

          By Using Parameters, We can select Maximum 1 Dimension at a time.

           

          Parameter: Parameters are variable, which are used to pass the values

          dynamically to the view.

          1) Create a Parameter for Dimension Selection purpose "Dimension Parameter", By using this Parameter, we can select the Dimension Value (Field) dynamically.

           

          9.png

           

          2) Create a Parameter for Measure Selection purpose "Measure Parameter", By using this Parameter, we can select the Measure Value (Field) dynamically.

           

          10.png

          3) Create a Calculated Field for Dimension Selection  using the syntax in the image.

          1`4.png

           

          4) Create another calculated field for Measure Selection like below image.

          15.png

           

          3) Place "Measure Selection", "Dimension Selection"  calculated fields, Right click on both Parameters & Click on "Show Parameter Control". (Note: We can  select Max 1 Value at a time from any parameter, It means Parameter limitation is Select Max 1 Value at a time.)

           

          11.png

           

          12.png

           


          13.png

           

          ==============================
          The following example explains when measures located on two databases.

           

           

          Create a Parameter5.png

           

          By using Parameter, create 2 Calculation for QS1, QS26.png

           

          7.png

           

          Then Place two measures on the Report like below image.Then you can define different marks for both measures.

           

          121.png

           

           

          When we select "QS1" from parameter,

          122.png

           

          When select "QS2",

          1123.png

           

          When Select "Both",

          121.png

           

           

          1 of 1 people found this helpful
          • 2. Re: Dynamically change row dimensions based on filter (multiple selections)
            Sankarmagesh Rajan

            Hi Jenni,

            Step1:

            Create parameter with string data type and list the below.Parameter name: [Multi select Dimension]

            Endpoint 1

            Endpoint 2

            Endpoint 3


            Step2:

            Create calc as [Multi Select Calc]

            If [Multi select Dimension] = "Endpoint 1" then [Endpoint Results 1]

            elseif [Multi select Dimension] = "Endpoint 2" then [Endpoint Results 2]

            elseif [Multi select Dimension] = "Endpoint 3 then [Endpoint Results 3]

            end

             

            Step3:

            Create [measure Parameter] and list

            Sales

            Profit

             

            Step4:

            Create calc as [Multi Select Measure]

            IF [measure Parameter]= "Sales" then [Sales]

            elseif [measure Parameter] = "Profit" then [Profit]

            end

             

            Step5:

            Drag this new calc into row and coloumn

            Row      : [Multi Select Calc]

            Coloumn: [Multi Select Measure]

             

            Step6:

            Show Parameter control in each parameters

            [Multi select Dimension]

            [measure Parameter]

             

            Select any dimension and measure then you can get good view.

            Thanks

            sankar

            • 3. Re: Dynamically change row dimensions based on filter (multiple selections)
              REDDY SEKHAR

              I am also looking for the same, but not in the parameter way. bcz the requirement is, multiple dimension selection filter has to show like multiple measure filter/ Quick filter on Dimentions