Forum Discussion

EstbanD's avatar
EstbanD
Copper Contributor
Sep 09, 2024

Macro Hierarchy Power Pivot Drill Up

Hello,

I need to do a macro that drill up my hierarchy in a power pivot table on the event workbook open but i don't know how to do that.

Thanks for you help !

excel
Macros and VBA

1 Reply

  • marilynroe's avatar
    marilynroe
    Iron Contributor
    Apr 25, 2025

    Four ways you may be able to help
    1.Missing relationships: make sure the dimension table is correctly associated with the fact table
    2. DAX Hierarchy Functions: use HIERARCHY() to build custom drill-down paths
    3. Pivot Table Settings: Enable 'Show Hierarchy Navigation Buttons' in Field Settings
    4. Finally: using Tabular Editor to directly modify the model metadata