Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

tannera

Hierarchy blanks issue

Submitted by Advocate II on ‎07-28-2017 05:40 AM

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.

Starting positionStarting position

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.

 

blank1_expand.PNG

 

The filter also shows these blanks, which makes it unusable in a professional environment.

 

FilterFilter

 

 

 

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. 

 

blank3_drilldown.PNG

 

 

 

 

This what the same hierarchy looks like in Excel. Everything works fine.

 

ExcelExcel

 

This what the same hierarchy looks like in Tableau. Everything works fine.

 TableauTableau

 

 

Is there any fix for it to behave like Excel or Tableau? 

Status: Accepted
See more ideas labeled with:
9 Comments (9 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎07-31-2017 12:30 AM

@tannera

 

I do not have such hierarchy in my SSAS cube. Could you please help provide a simple sample table which can be used to deploy the tabular solution and repro this issue?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎07-31-2017 12:31 AM
Status changed to: Needs Info
 
tannera
Advocate II
Advocate II
‎07-31-2017 06:02 AM

 It turns out it isn't a simple hierarchy, but a recursive parent child one. Does Power BI support these? Excel and Tableau aparently do.   

tannera
Advocate II
Advocate II
‎08-03-2017 07:50 AM

I've sent through PM (since file attachments are not supported directly in these forums) a minimal cube with  a replication of the problem.

 

I will update on any updates on this issue. 

tannera
Advocate II
Advocate II
‎08-23-2017 02:55 AM

Any update on this? This problem is still present in the latest August release of Power BI. 

 

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎08-23-2017 08:04 PM

@tannera

 

I’ve reported it internally to Power BI Team: CRI 45701536
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎08-23-2017 08:07 PM
Status changed to: Accepted
 
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎08-25-2017 12:16 AM

@tannera

 

I’ve got response from the Product Team.

 

Currently this is not supported in the product. Please vote on the ideas site. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/14511612-ragged-or-parent-child-h...

 

Best Regards,
Herbert

kemmerrc
Helper I
Helper I
‎04-21-2022 05:49 AM

Is there a resolution to hierarchy issues with blanks. I have organizational levels from 1-12. Obviously, not all our groups go to a level 12. As stated in this chain, the hierarchy dropdown is useless. Is there a way to make it ignore blanks?  

Idea Statuses