Forum Discussion

juandroid's avatar
juandroid
Icon for Helper I rankHelper 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...
  • v-qiuyu-msft's avatar
    8 years ago

    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