How to drill down from a summary table to the data

[venkatsaisivaku]

Hello team,

I have a requirement  to drill down from a summerised table to the actual data.

I have create a summary table as bellow  using the columns

bagrespinfo_acftnumber_column,

bag_tag_ispriority_column,

bagrespinfo_arrivalstation_column

, and I want to go to the actual data on clicking any of these numbers in the graph. In this case on pressing on 2-49 I want the actual data that constuites to it to be shown in the bellow table

Thanks in advance.

[venkatsaisivaku]

@Kishore_KVN Thanks for your response.I have tried this and also enabled the drill through feature , But cannot drill through.

Please advise if I am missing something. Thanks in advance

[Kishore_KVN]

Hello @venkatsaisivaku , you have to add it in different page not in same page. Add data in Page 1  and in that page add data to drill through fields then from page 2 to page 1 you can drill through. 

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

[Kishore_KVN]

Hello @venkatsaisivaku ,
step1: create new page with all details

step2: Add finaldestination column into drilldown options and summarize it. 

step3: Add PK_Column as well into drilldown options

step4: you can hover or right click on 2149 in summary page it will give you option to drill down. From drill down page you can come back to summary page using back arrow created automatically. In Power BI desktop you have to hold Control key.

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