9 Replies Latest reply on Sep 2, 2016 7:50 AM by Ramz Aftab

    How use ACTION filters to filter another chart in dashboard with child members

    Ramz Aftab

      Hi Experts,


      The below extract shows A,B,C as measures and Achild, Bchild and Cchild are there child measures. Since we cannot make any hierarchy for Parent/Child in measures, there's unfortunately no link between A and Achild in Tableau. Therefore, it's not possible for me to create ACTION filter in dashboard chart# 1 to select/filter display child members in Chart#2.

       

      If I select eg. A measure in blue, it should filter and display Achild in second chart over the 3 months. Since there's no linkage between them, the only thing common it considers is date in Target sheet (ie Chart#2).

       

      Can someone help me here ? I have attached excel extract and Tableau workbook.

       

      Thanks,
      Ramz

       

       

       

       

       

       

      DateEntityABCAchildBchildCchild
      1/1/2016One195026144521
      1/1/2016Two474637424132
      2/1/2016One32311227267
      2/1/2016Two182127131622
      3/1/2016One492937442432
      3/1/2016Two41143336928