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

[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.