Forum Discussion
Cannot expand next hierarchy in Matrix
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.
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
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:
That's strange.
Have you tried expanding the hierarchy using the drill down button of matrix?
Ya, that's weird, it's some kind of error.
I tried drill down button or right clicked on the row then chose expand/drill down as well but it cannot go to next level of hierachy.
There are negative signs on the rows of Week number, which indicates it's has been expanded but nothing there inside.
Is it possible for you to share the sample pbix file?