Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cannot expand next hierarchy in Matrix

I found an issue in a visual in Power BI service.

I have a hierarchy of Rows: Month -> Week -> FltDate. But I cannot expand to the level of FltDate.

 

And when I try fixing it in edit mode, removing and re-inserting FltDate to the Rows, it works. But when I save the report and reopen it in view mode, everything remains, it cannot be expanded

 

 

 

Help required
Issue
  • Anonymous's avatar
    Anonymous
    4 years ago

    I try to remove and reinstate 'Month' again to Rows field and It's now OK somehow.

    There is nothing wrong with the pbix file, it works well in PBI Desktop. It's about the report mode in PBI Service.

    Besides I cannot share the file because it queries data from our company server.

11 Replies

  • PC2790's avatar
    PC2790
    Community Champion
    4 years ago

    Check the datatype of the FltDate once and also double check on the filters applied by hovering over the funnel on the top left corner of the visual.

    It could be that there is no data for displaying because of the filters applied

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      FltDate is datetype and also marked as date table and there is always data at date level. And this issue occurs in PBI service only. When I go to edit mode (in the service), remove and bring it back, it works well. But when I save and go to report mode, it fails again :(.

       

      This is in the edit mode, after I remove and reinstate it:

       

      • PC2790's avatar
        PC2790
        Community Champion
        4 years ago

        That's strange.

        Have you tried expanding the hierarchy using the drill down button of matrix?

         

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    4 years ago

    HI Anonymous ，

    Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.And if not ,could you pls share your pbix file ,and remove confidential data.

     

     

     

    Best Regards
    Lucien

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I try to remove and reinstate 'Month' again to Rows field and It's now OK somehow.

      There is nothing wrong with the pbix file, it works well in PBI Desktop. It's about the report mode in PBI Service.

      Besides I cannot share the file because it queries data from our company server.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I've come across this bug as well. You expand a node, and nothing appears under it. Work around is to edit the page, remove the lowest level field and readd it.

         

        It's not just limited to date data types. I am using customer Bill To names drilling down to Ship To names.

  • jandslm's avatar
    jandslm
    Frequent Visitor
    1 year ago

    I am experiencing same issue 4 years later.   Did anyone ever discover how to resolve this?