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 don't use any measure in this matrix.
I used two work items types in the matrix: Bug and Task, which are related in the data model.
The hierarchy used (lines) is as follows:
1) Task Closed Date (yyyymm)
2) Bug Area Path
3) Task Work Item Id

 

The first figure presents the matrix displayed in the Power Bi Desktop the second one presents the matrix displayed in the Power BI app.

 

 

Could you help me to solve this problem?

Need Help

16 Replies

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

    Can you update your screenshots so that both include the visual header with the drill up/down/expand icons?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Here is the screenshots.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I forget this: On PC of other colleagues this problem doesn't happen.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Please check in Power BI Desktop if the options marked in the figure below are checked.
    If so, please try unchecking Hide the Visual Header in Reading View and republish.

    Best Regards,
    Community Support Team _ Caitlyn

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous 

       

      This option was already checked as you showed.  

      Please, see the screenshot below,

      Thanks.

      Regards.

  • Felo's avatar
    Felo
    Regular Visitor
    2 years ago

    Hi there,

     

    I had the same issue. Resetting the dashboard worked for me.