cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jppp
Advisor

Re: Hierarchy Slicer - Unexpected Error

Usually two business days (from my experience). But no guarantee.  

Mardin
Advisor

Re: Hierarchy Slicer - Unexpected Error

Thanks a lot Jan! Much appreciated!

 

While I'm at it can I ask you a quick question: In the 1.0.3.0 you mention ragged hierarchies/empty leafs. I suppose this option will remove the "blank" selections in my ragged hierarchy. Do you have any articles/tutorials on how to format the data to allow this feature? I'm asking since I still see my "blank" boxes no matter if I enable or disable Empty Leafs.

jppp
Advisor

Re: Hierarchy Slicer - Unexpected Error

Hi, I have not yet a tutorial or any docs regarding, but its is a good point: I will update it this weekend.

 

The hierachy levels (columns) that should be ignored need to be formatted as an empty/blank value in the source. IF that is the case, then the option 'Empty Leafs' will not show those level values.

 

-JP

ANAMM Frequent Visitor
Frequent Visitor

Re: Hierarchy Slicer - Unexpected Error

Hi Jan. Works perfectly here Smiley Happy

 

I just played around with the possibilities and have a bit of feedback. I often work with an organizational hierarchy where ragged hierarchies are very nice to have, but I have the employees in each department in another table and would really like to be able add them to the hierarchy – I am able to do this, but when turning “Empty Leafs” off all employees belonging to an empty leaf are not shown. What I am doing are the following:

 

Table “Employees”:

Dep num:        Name:

1                       Jan

2                       Martin

2                       Anders

 

Table “Organization”:

Dep num:         Org Level 1       Org Level 2

1                       Sales

2                       Sales                 EU

 

Where Dep num is used to link the two.

 

With “Empty Leafs” turn on this shows as:

Sales – (Blank) – Jan

Sales – EU – Martin

Sales – EU – Andres

 

With “Empty Leafs” turn off it becomes:

Sales

Sales – EU – Martin

Sales – EU – Andres

 

It would be really nice if it could remove the blanks but show “Jan”, at the level where he belongs:

Sales – Jan

Sales – EU – Martin

Sales – EU – Andres

 

Not a deal breaker as I can probably merge the two tables to get a similar behavior, but if it was part of the visual it would be really nice J

Re: Hierarchy Slicer - Unexpected Error

Any update on the resolution of this error? We use hierarchy slicers on almost every page of our reports since we report on multiple hierarchies. Making changes in Power BI Desktop is frustrating. Thank you!

Re: Hierarchy Slicer - Unexpected Error

<p>Any update on the resolution of this error? We use hierarchy slicers on almost every page of our reports since we report on multiple hierarchies. Making changes in Power BI Desktop is frustrating. Thank you!</p>

jppp
Advisor

Re: Hierarchy Slicer - Unexpected Error

Hi, thanks for the feedback.

And this scenario is indeed not supported with the ragged hierarchies option I use, but it is an interesting one.

I will put it on my backlog.

 

Thanks, JP

 

jppp
Advisor

Re: Hierarchy Slicer - Unexpected Error

And the visual is still in approval/review phase. Unfortunatelly it is taking a little bit longer.

 

Thanks, JP

nborn1 Frequent Visitor
Frequent Visitor

Re: Hierarchy Slicer - Unexpected Error

Will you post an update once this is approved? Almost all of my reports are affected as well. Since we're close to month end, this is causing a lot of problems. Thanks!

langer83 Frequent Visitor
Frequent Visitor

Re: Hierarchy Slicer - Unexpected Error

I experienced the same issue in the July version but not immediately after the upgrade. I found out about this error after the gateway refresh started failing and narrowed the issue down to the hierarcy slicer. I replaced all the hierarcy slicers with the default slicer to solve the issue. Not ideal but at least the report and gateway work now.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 84 members 1,579 guests
Please welcome our newest community members: