Drilldown Table Help

Hi Anonymous,
Thank you for reaching out to the Microsoft fabric community forum. Thank you bhanu_gautam, for your inputs on this issue.
After reviewing the details you provided, I have identified few workarounds that may help resolve the issue. Please follow these steps:

Verify Date/Week Column Format: Ensure the date column or week identifier is correctly formatted (e.g., as a week number or date). The drill-down should rely on this column.

Establish a Week Hierarchy: When using tools like Power BI or Excel, create a date hierarchy with fields for the current week and past weeks. Ensure the week field is accurately categorized and ordered in the hierarchy (e.g., Current Week → Week 1 → Week 2 → etc.).

Implement DAX Measures for Filtering: Use a DAX measure to identify the current week. Example formula in Power BI:     IsCurrentWeek = IF('Date'[WeekStart] = TODAY(), 1, 0)
Apply this measure to conditionally format or filter the table so that the current week is displayed by default.

Enable Drill-Down Functionality: Ensure drill-down functionality is activated, typically by setting up a hierarchy (Project → Division → KPI → Week) and configuring the visual to allow users to click on a level (such as the current week) and drill down to previous weeks.

Correctly Sort Data: Ensure the data is sorted appropriately (e.g., by date, with the current week appearing first). This can be achieved using a calculated column or measure to sort by week number or date.

Test with Sample Data: Create a simplified version of the table with sample data for validation. Verify that the drill-down works as expected when clicking on the current week and navigating to past weeks.

Kindly refer to the below link for better understanding:
Drill mode in the Power BI service - Power BI | Microsoft Learn
Drillthrough, drilldown, subreports, and nested data regions in a Power BI paginated report - Power BI | Microsoft Learn

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.