Forum Discussion

Mardin's avatar
Mardin
Advocate IV
9 years ago
Solved

Hierarchy Slicer - Unexpected Error

Hi, Today I opened a .PBIX file where I use the Hierarchy Slicer. The moment after the report was opened in PowerBI Desktop I got this message: ------- Unexpected Error An error occured while ren...
Need Help
  • jppp's avatar
    jppp
    9 years ago

    All,

     

    I have submitted a new version for approval that fixes the 'unexpected error' and after approval it will be available asap.

     

    Sorry for the inconvenience.

     

    Thanks, JP

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Great!  Any idea how long that usually takes?

 

jppp's avatar
jppp
Continued Contributor
9 years ago

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

  • Mardin's avatar
    Mardin
    Advocate IV
    9 years ago

    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's avatar
      jppp
      Continued Contributor
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Jan. Works perfectly here :smileyhappy:

         

        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