Forum Discussion
Drill through from parameter field columns
Hi,
May I have your help on a situation where drill through is needed from columns of parameter fields?
I have a fact table called "Actual overall" which has relationship with TblDate. The fact table has all the transaction from Jan 2024 to July 2025. I have initiated the following table visual in Power BI.
My goal is to drilling through on both 2025 Actual column and 2024 Actual column depends on the selection. The chart above the table is parameter fields using measures.
For your reference, the column or parameter field "2025 Actual" using CALCULATE to field the actual table for Jan - Jul 2025 actual only, same logic applied to "2024 Actual" (Jan - July 2024 actual only).
Now I am stuck on how to drill through on different columns? Can you please help me? Thanks,
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.
6 Replies
Hi 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.
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.
Hi annatan,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further
Thank you.
Hi annatan,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
Hi annatan,
We haven’t heard back from you in a while regarding your issue. let us know if your issue has been resolved or if you still require support.
Thank you.
