Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Second level hierarchy in matrix doesn't work

I use visual matrix to demonstrate information of work items (from Azure Devops). Data is displayed in 3 hierarchies in Power BI Desktop but in the Power BI app only 2 hierarchies are presented. I do...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ok, thanks.

 

Here is the screenshot in the service. 

otravers's avatar
otravers
Icon for Community Champion rankCommunity Champion
4 years ago

Looks like you need to click on the Expand button to get to the deepest level of your hierarchy, like you have it in Power BI Desktop:

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I have done that and the problem persists. I also have tried enabling drill down and it didn't work either.

    • otravers's avatar
      otravers
      Icon for Community Champion rankCommunity Champion
      4 years ago

      You 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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