Forum Discussion
Hierarchy and Show Different Levels
Hi Anonymous ,
Thanks for reaching out to Community Forum.
I was able to reproduce this using a simple sample model (attached .pbix). The issue is not related to Power Query but to how Power BI evaluates hierarchy context in visuals. Instead of duplicating or hard coding values in Power Query, this can be handled dynamically using DAX. I created a standard hierarchy Level1Name -> Level2Name -> Level3Name and used an ISINSCOPE based measure to detect the active drill level and return the appropriate name automatically. With this approach, Level 1 shows the Level1 name, Level 2 shows the Level2 name, and Level 3 shows the Level3 name, while fully preserving drill down behavior.
The below attached .pbix demonstrates the correct output at each drill level.
Thank you.
Hi Anonymous ,
Thanks for reaching out to Community Forum.
I was able to reproduce this using a simple sample model (attached .pbix). The issue is not related to Power Query but to how Power BI evaluates hierarchy context in visuals. Instead of duplicating or hard coding values in Power Query, this can be handled dynamically using DAX. I created a standard hierarchy Level1Name -> Level2Name -> Level3Name and used an ISINSCOPE based measure to detect the active drill level and return the appropriate name automatically. With this approach, Level 1 shows the Level1 name, Level 2 shows the Level2 name, and Level 3 shows the Level3 name, while fully preserving drill down behavior.
The below attached .pbix demonstrates the correct output at each drill level.
Thank you.
Hi Anonymous ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi Anonymous ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions