Identifying drillthrough on which measure?

[Anonymous]

Hi,

i have around 5 measures in 5 different charts in the main page and i would like to drillthrough on each of those measures,

is there a way that my drillthrough report display only the measure on which i have drilled from the main report.

i would like to drillthrough to only one page and i dont want to create multiple copies of the drillthrough report for different measures.

Regards

CLR

[ChristineL]

Hi, I have the same question and I was wondering how to reduce the number of drillthrough pages. The only difference is that I am counting the wins in total, which will be my first measure. All other measure are calculated with an addinional filter on the period (3 month, 6 month or 12 month). Currently I have a drill through page for each measure as the filter on period is in the measure definition:

Wins 12 months =

CALCULATE (

    [Wins],

    '00_fact_table'[payment_plan] = 12

).
Instead of using a drill through page for each measure I would like to use the same drill through page for all measures: Wins, Wins 12 months, Wins 6 months and Wins 3 months, which means I would add all measures in the drill through page as drill through fields. And based on which drill through field has been used to drill through to this drill through page I am filtering the result on the period (3 month, 6 month or 12 month). Is this possible?

[ClintReeves]

I have a similar need, did you ever get a solution?  

[arsggnb]

39.36.196.251

[v-danhe-msft]

Hi @Anonymous,

Based on my test, if your 5 different charts have the same field, I suggest you use the same field as the drillthrough field and all of them could drillthrough the same drillthrough page:

Mian page:

Drillthrough page:

Both of the visuals could drillthrough to the same page.

Hope it could help you.

Regards,

Daniel He

[Anonymous]

 Hi @v-danhe-msft, i only have the measures displayed on the bar chart and there is no dimension fields on those charts... its just like a card visual but its a bar chart with a measure on it as we cant do drillthrough on a card visual.

All of those are different measures(cost measure) and i need to display for each measure how the cost is divided across multiple plants on my drillthrough report.

i would like to know is there a way to create only one drillthrough page and change the measure based on the measure i am drilling?

i know there is a way to create multiple drillthrough reports but i dont want to create drillthrough page for each of those measures

Regards

CLR

[v-danhe-msft]

Hi @Anonymous,

I have tried create multiple cards visual in drilltrough page and set the drillthrough filter, it could work to drillthrough but I could not sure if it could meet your requirements, could you please post me your desired result if possible?

Before drillthrough

After drillthrough:

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft,

i dont have any issues in implementing the drillthrough functionality, Please find the test file which i have created below.

TestReport.pbix

i have two measures in the main report {Sales,Total Units} and two separate drillthrough reports to display these two measures by Region. 

i am trying to minimize the number of drillthrough reports since i am using the same Region field in both the reports by changing the measure and hence i would like to know is there way we can identify on which measure we are drilling in based on that i can create only one drillthrough report and change the measure accordingly.

Hope this clarifies the question.

Regards

CLR

[v-danhe-msft]

Hi @Anonymous,

Have you tried put both measures into the drillthrough bucket?

Regards,

Daniel He

[Anonymous]

Hi @v-danhe-msft,

i only need one and i dont need two measures on drillthrough report.

Here is the current scenario:

if drillthrough on measure1 then it redirects to drillthroughreport1

if drillthrough on measure2 then it redirects to drillthroughreport2

what i am trying to achieve is identifying the measure on the main report and change the respective measure in the drillthrough report,so that i dont need to create two drillthrough reports. 

Hope this clarifies the question to you.