How to show intermediate summary data

[Anonymous]

Hi All,

          need your help and guidance on one  of the requirement . 

iam creating a report in which the requirement is that i have to navigate from summary page to detail page where the data has to show intermediate aggreagtion as some chunks and when i navigate to deatil page to detail1 page it has to show all the detailed data .

currently iam using drill through functionality from summary to detailed but when iam selected particular row in detail page itself it is showing the detailed level,but my requirement is like above excel .

could somebody

[HarishKM]

@Anonymous Hello,
You can simply load the table then select a table visual and then drag country, Year, Sales. then you will have desired result.
3 steps are requires

Step 1: Create a summary page.
Step 2: add a bookmark for navigation to detail page.
step3 : create a detail page.
step4 : Create a detail1 page.
Step5: add a bookmark for navigate to detail1 page.

You can also refer to this
Page navigation :Create page and bookmark navigators - Power BI | Microsoft Learn
Drill through report: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Thanks
Harish M