Drill Down implementation issue on Table View in Power BI.

[Anonymous]

We are facing issue on Drill Down approach on Table View, how we can implement the Drill Down on table, Please find below requirement and Some Question.

1. Actual Requirement:
When user will click on metric data which is shown as per the Quarterly basis on table, it should show the detailed data on daily basis on same page and it should be pagination which user can scroll down. For exmaple one aggregated quaterly data is 100 row of daily data then 1000 rows of daily data should be visible in bottom on page report which can be scroll up and Down. 
The data on table is visbile as per the L2 table, and user want to show data as per L0 and L1 table after clicking on particular Value.

Question 1. Is possible to implement Drill Down approach on Table view ? If yes , How we can implement the same?

Question 2.  Can we try using Drill through Approch ? by taking L0 and L1 Table.

Question 3: Can we create a paginated report for detailed information and link it with metric name in report? 

[Anonymous]

We can not use martix table. It should be Normal Table.
We are implementing drill down for one report. where we need drill levels quarter and previous years  in same page vizualization where business will scroll down to view the report. 

[bhanu_gautam]

@Anonymous , For first question :-it is possible to implement a drill-down approach in Power BI on a table view using Hierarchies and matrix visual

For second question :-

Create Drill Through Page: Create a new page in your Power BI report that will serve as the drill-through page. This page should contain the detailed data (L0 and L1 tables).

Add Drill Through Fields: On the drill-through page, add the fields that you want to use for the drill-through filter to the "Drill through" section in the Visualizations pane.

Set Up Drill Through: On your main report page, right-click on the metric or value you want to drill through from and select "Drill through" -> [Your Drill Through Page].

Navigate Back: Ensure you have a button or link to navigate back to the main report page.

For third :-

Yes, you can create a paginated report in Power BI and link it to your main report. Here’s how:

Create Paginated Report: Use Power BI Report Builder to create a paginated report. This report can handle large amounts of data and supports pagination.

Publish Paginated Report: Publish the paginated report to the Power BI service.

Link to Paginated Report: In your main Power BI report, you can create a button or a link that navigates to the paginated report. You can use a URL action to pass parameters to the paginated report if needed.

Integration: Ensure that the paginated report is integrated seamlessly with your main report by using consistent filters and parameters.

[Anonymous]

We can not use martix table. It should be Normal Table.
We are implementing drill down for one report. where we need drill levels quarter and previous years  in same page vizualization where business will scroll down to view the report.