Daniel Castro on 04 Jun 2020 07:21:10
When using the martrix visual (which is the one most similar to Excel Power Pivot), hierarchies empty level are not hidden and it is possible to keep expanding empty levels of the hierarchy. Hierarchy empty levels are quite common in ragged hierarchies. Excel hides this levels.