Forum Discussion
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 !
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