Forum Discussion

mfranusiak's avatar
mfranusiak
Frequent Visitor
8 years ago
Solved

Drilldown Hierarchy based on Different Fields

Hello, I have a requirement to drill down to different values based on the currently level. 

For example, I have a financial report displaying returns for a product and fund. The returns are different for both the product and fund and cannot be aggregated through the typical drilldown like other numbers (such as sales amount). 

 

Product will be the main level with it's own returns which will have a sub level of funds which will have their own returns.

Basically I'm trying to figure out if it's possible to change the value field based on the hierarchy level. If I click on the drilldown, the next values should not be the same as the previous hierarchy.

 

 

Thank you.

  • v-caliao-msft's avatar
    v-caliao-msft
    8 years ago

    mfranusiak,

     

    If it's possible to change the value field based on the hierarchy level. If I click on the drilldown, the next values should not be the same as the previous hierarchy.

    Currently, there is no such a function to achieve this requirement in Power BI. 

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao

2 Replies

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

    mfranusiak,

     

    If it's possible to change the value field based on the hierarchy level. If I click on the drilldown, the next values should not be the same as the previous hierarchy.

    Currently, there is no such a function to achieve this requirement in Power BI. 

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao