When the hierarchy does not expand equally on all levels, it creates blanks. This is not the case with Excel or Tableau using the same data source (SSAS cube, live connection). It makes Power BI unusable for users with hierarchies in their cubes.
This is what it looks like without drilling-down/expanding the hierarchy. Everything is fine.
Here is where the problem is at, the hierarchy shows blanks because not all levels expanded to the same depth, it created blanks for those that do not go as deep.
The filter also shows these blanks, which makes it unusable in a professional environment.
This is with the drilling down option instead of expanding, the yellow highlighted parts show the problematic parts compared to the same table in Excel, which implements the hierarchy correctly.
This what the same hierarchy looks like in Excel. Everything works fine.
This what the same hierarchy looks like in Tableau. Everything works fine.
Is there any fix for it to behave like Excel or Tableau?
-
v-yetao1-msft
on:
Do I need another version of PowerBI to share a re...
-
v-yetao1-msft
on:
Datamart deployment
-
v-yetao1-msft
on:
Change translation of Report view to Swedish
-
v-xiaoyan-msft
on:
How do I get a table to correctly show the bullet ...
-
v-yetao1-msft
on:
Live excel export not respecting "show items with ...
- MaPol on: Sequence contains more than one matching element i...
- BernhardSpitzer on: BUG: Use Azure GIT integration for PowerBi report ...
- AHeyman_ on: Export to PPT/PDF always takes default values
- christianirgens on: Analyze in Excel (app)
- Sinwan on: Element 'return' was not found. Line 1, position 2...