Forum Discussion

nguyea25's avatar
nguyea25
Frequent Visitor
9 months ago
Solved

Issue with hierarchy getting stuck when switching parameters on slicer

Hello All!   This seemed to be working perfectly before however, I'm seeing my hierarchy in tables get stuck both in the Power BI Service and on Desktop when switching between parameters using slic...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    9 months ago

    nguyea25 

     

    This is a known limitation in Power BI. The visual retains drill levels and doesn’t reset automatically when toggling between different hierarchies, especially if one view has fewer levels.

     

    Fixes:

    1. Add a bookmark button that resets the drill state (drill-up all levels) so users can quickly “unstick” the hierarchy.

    2. Avoid mixing simplified hierarchies with detailed ones in the same field parameter group; keep hierarchy depth consistent across views.

Kedar_Pande's avatar
Kedar_Pande
Icon for Super User rankSuper User
9 months ago

nguyea25 

 

This is a known limitation in Power BI. The visual retains drill levels and doesn’t reset automatically when toggling between different hierarchies, especially if one view has fewer levels.

 

Fixes:

1. Add a bookmark button that resets the drill state (drill-up all levels) so users can quickly “unstick” the hierarchy.

2. Avoid mixing simplified hierarchies with detailed ones in the same field parameter group; keep hierarchy depth consistent across views.

  • nguyea25's avatar
    nguyea25
    Frequent Visitor
    9 months ago

    Thanks for the idea. Our users were happy with the way it work previously and now used to being able to select a view without having the levels get stuck. They keep reporting it as an issue/bug. I really hope MS fixes this.