Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Identifying drillthrough on which measure?

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

Need Help

9 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

       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's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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

  • ChristineL's avatar
    ChristineL
    Regular Visitor
    1 year ago

    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?