Forum Discussion

juandroid's avatar
juandroid
Helper I
8 years ago
Solved

Drilltrought filter

Hi Guys!

 

I have the next example data:

 

Account     Name      Value

1105          cash         500

110501      cash2       100

110502      cash3       300

110503      cash4       100

1110          banks       300

111001      banks2     100

111002      banks3     100

111003      banks4     100

 

I create a table report that shows only the "mother cod" (the 4 digits accounts and its called mother because it adds all the values from the sons, the 6 digits accounts) and the result was:

 

Account     Name      Value

1105          cash         500

1110          banks       300

 

I want to create a Drilltrought page that show other info of the account, including the sons. So for example, if I make right click in the CASH account on the previous data table, and go to the drilltrought, I want to appear a data table like this:

 

Account     Name      Value

110501      cash2       100

110502      cash3       300

110503      cash4       100

 

I don't know if this is possible but I really hope it can.

 

Thanks in advance,

 

 

 

 

 

 

  • Hi juandroid,

     

    It's possible in Power BI desktop September version, but you need to optimize your sample data firstly. The parent account 1105, 1110 need to be in a separate column like below: 

     

     

    Then you can create a Drillthrough report page, drag the Parent column to Drillthrough filters pane. Create another report page named Main, when you right click the 1105 and select Drillthrough, it will drill through to the Drillthrough report page and filter data. You can download the attached pbix to have a look. 

     

     

     

    Reference:
    Use drillthrough in Power BI Desktop

     

    Best Regards,
    Qiuyun Yu 

3 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support

    Hi juandroid,

     

    It's possible in Power BI desktop September version, but you need to optimize your sample data firstly. The parent account 1105, 1110 need to be in a separate column like below: 

     

     

    Then you can create a Drillthrough report page, drag the Parent column to Drillthrough filters pane. Create another report page named Main, when you right click the 1105 and select Drillthrough, it will drill through to the Drillthrough report page and filter data. You can download the attached pbix to have a look. 

     

     

     

    Reference:
    Use drillthrough in Power BI Desktop

     

    Best Regards,
    Qiuyun Yu