Drill through page with different direct queries same field now working as expected

[tina345]

Hello, I have

Page1

     - table /Pie Chart which uses query1

Page2

      - slicer, table & barchart uses query1

       - Linechart uses query2

When I drill through from 1st page to 2nd page with common field 'column1', linechart from query2 is not working as expected and still shows everything regardless of selection.Whatever coming from query1 is working but linechart which uses query2 is not.Do we need to make any relation between query 1 and query2 to make it work?

[Anonymous]

Hi @tina345 ,

Has your problem been solved? I agree with @ebeery . 

You should put column1 in the drill through field in Page2.

You can download my sample file to check.

Best Regards,

Stephen Tao

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

[ebeery · Accepted solution]

@tina345 column1 would need to be related to both query 1 and query 2 (with the proper filter direction) in order for the linechart using query 2 to be affected by the drill-through.