Forum Discussion
Drill Through on multiple measures
Hello,
i have multiple measures that have filters on them to show me the values i need, for examples revenues, cost of sales, gross profit, etc...
i have a table that has the name if those measures that i use to choose what KPI i want to show on my column chart using a measure with a switch case.
i was wondering if there is a way to drillthrough from the column chart to another page, and display the amount of the selected measure and month from the chart on a table with specific accounts for each measure?
for example if i drill through on revenue measure show account 1 and 2, if i drill on cost of sales show accounts 3 and 4, etc...
You can drillthrough from any visual, even if the displayed value comes from a measure.
However, the drillthrough always uses the exact filter context coming from the source visual — it cannot switch, adjust, or reinterpret the context based on a different measure or a different business rule.In other words:
Drillthrough does not pass the measure, it passes the filter context that produced the value you clicked.
The target page will always show the exact same context, recalculated there.
If you expect different detail rows for different measures (e.g. different account sets), this is not a drillthrough feature, it requires a field in the data model that distinguishes the logic (e.g. Account Group, KPI Type, Category, etc.).
Without such a field, Power BI cannot identify which detail logic belongs to each measure, because drillthrough is strictly context-based and source-visual driven.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
You can drillthrough from any visual, even if the displayed value comes from a measure.
However, the drillthrough always uses the exact filter context coming from the source visual — it cannot switch, adjust, or reinterpret the context based on a different measure or a different business rule.In other words:
Drillthrough does not pass the measure, it passes the filter context that produced the value you clicked.
The target page will always show the exact same context, recalculated there.
If you expect different detail rows for different measures (e.g. different account sets), this is not a drillthrough feature, it requires a field in the data model that distinguishes the logic (e.g. Account Group, KPI Type, Category, etc.).
Without such a field, Power BI cannot identify which detail logic belongs to each measure, because drillthrough is strictly context-based and source-visual driven.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thank you for reaching out to the Microsoft Fabric Forum Community.
Ritaf1983 Thank you so much for your inputs.
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
