Forum Discussion
Helper IIDrill through from parameter field columns
Hi annatan,
You should add a separate year column directly to the dataset, not just in the visual, to enable the drill-through option as recommended by the superuser. After that, you can use a measure.
Drillthrough in Power BI Reports: Navigate to Detailed Insights - Power BI | Microsoft Learn
Thank you.
Super UserHi annatan
Drillthrough in Power BI doesn’t work directly on parameter/measure columns, it only works on fields in the data model. To achieve your scenario:
- Instead of creating separate “2024 Actual” and “2025 Actual” measures as columns, unpivot or create a Year column in your fact table (2024, 2025, etc.).
- Build a measure like:
- Actual Value =
- CALCULATE ( SUM ( ActualOverall[Amount] ), YEAR ( TblDate[Date] ) = SELECTEDVALUE(YearTable[Year]) )
- Use that Year field for drillthrough filter. Then the same drillthrough page will respond to whichever year/column (2024 or 2025) is selected.
You need a proper Year dimension field to pass as drillthrough filter. Measures/parameter columns alone can’t trigger drillthrough.
Helper IIHi rohit1991
Thanks so much for your suggestion.
Do I make any changes on the table visual I provided above? Did you mean just keeping the same table and create a new suggested measure. Thanks
v-saisrao-msftCommunity Support
Hi annatan,
You should add a separate year column directly to the dataset, not just in the visual, to enable the drill-through option as recommended by the superuser. After that, you can use a measure.
Drillthrough in Power BI Reports: Navigate to Detailed Insights - Power BI | Microsoft Learn
Thank you.