Drill Through in Parent Child Hierarchies

[abhiram342]

Hi all - I have table with parent-child ids along with Levels. One of requirement is table to see Parent information on the same page when User click on ParentId column in table chart i.e Clicking On ParentId should display information about it.

I'm not sure If I can achieve it on same page hence I tried with drill through approach by cloning the exisitng page but It's not working. Please suggest if there are any  other approaches to achieve the functionality.

Also, Is there option to update Slicer based on Selected Column in Table Chart?

Example:

Data:

Clone the Page and Enable Drill Through:

Verify Drill through Option on Summary Page:

Clicking on Drill Through gives the data for ParentId = '0728b2f0' but I'm looking for ParentId information i.e PipelineId = ParentId(0728b2f0).

Please assit

Thanks,

Abhiram

[lbendlin]

You are already using a matrix visual which shows both levels. Not sure what additional information you are after?  Have you considered tooltips instead?

Also, Is there option to update Slicer based on Selected Column in Table Chart?

Slicers cannot be set programmatically. You can limit the UNSELECTED choices via the filter context. BUT whatever is selected stays selected even if it falls out of the filter context !!!  That's one of the reasons why slicers with default selections are incompatible with RLS.