Forum Discussion
Second level hierarchy in matrix doesn't work
Community ChampionYou need to click again on Expand until the Expand icon is greyed out (no longer clickable). In your screenshot the Drill Up icon is greyed out, showing that you haven't drilled down through your hierarchy.
You can also save the drilled and expanded state in Power BI Desktop in a bookmark, then apply that bookmark in the service.
Hi otravers,
Thank you very much for your attention and tips.
But unfortunately I had already done what you described in power bi service and power bi desktop.
In the Power Bi Service, I clicked on the Expand icon several times and it stays the same way (clickable and not greyed out).
I think it must be a configuration issue because the problem of not expanding the hierarchy doesn't happen to other people in my organization.
Regards
- otravers
This is weird and looks like an outright bug. I use hierarchies all the time and never ran into this behavior. Even the bookmark doesn't work?
Is the bookmark the drilldown icon?
Neither the drilldown icon nor the "+" or "-" sign works.- otravers
Bookmark is another feature which will let you save the drill down status in Power BI Desktop, then apply it in the Power BI service:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks
I hadn't used the bookmark.
This is weird because other persons use the same report/visual that I published and the hierarchies work.