Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Drill through selections

Hi Experts

Not sure if this is a problem or a normal feature of drill through. I have four drill through pages on my report.
1. America's
2. EMEA
3. APAC
4. REST

When I go to the America page and I right click on the visual to drill through it give me the option to drill through to all of the above as opposed to just America's. Am I doing something wrong or is this a standard feature of BI.
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    What does you data look like? How do you use "drill through"?

    I test with a simple dataset.

    1.

    2. add "area" in a table visual on page1, "details" in a table visual on page2,

    3.add "area" in the "Dill through" filter on the page2.

    3. select "America's" and drill through to page2,

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

4 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    What does you data look like? How do you use "drill through"?

    I test with a simple dataset.

    1.

    2. add "area" in a table visual on page1, "details" in a table visual on page2,

    3.add "area" in the "Dill through" filter on the page2.

    3. select "America's" and drill through to page2,

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago
      I Maggie firstly thanks. I did the same step Now trying doing that when you have three similar tables for each of the region's. See what the drill through option is. If you are on the America's page the drill through allows the use to see when right clicking on the table the ability to Sri through to APAC also. I'll post an image sortly
      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous 

        Is your problem sloved?

        It seems you need to to add proper column in the "Dill through" filter on the drill through target page.

         

        Best Regards

        Maggie

         

        Community Support Team _ Maggie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.