Forum Discussion

Ximo's avatar
Ximo
Frequent Visitor
4 years ago
Solved

Working with Project Online lookup table multivalue hierarchical structure

Hi all, I am working on a Power BI slicer to filter projects depending on the department. The Lookup table from Project Online is:     For this Departments field (not the OOB Department fro...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    I tried tinkering with this some. See if the attached helps at all.

     

Ximo's avatar
Ximo
Frequent Visitor
4 years ago

Hi AlexisOlson 

Do you know why there are some blanks in some departments? Any tip to get rid of them?

Thank you!

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

It's because there aren't any deeper levels but something has to be in the level 4 column. I just left them unexpanded. I don't think you can get rid of them without fundamentally changing the dimension structure.

  • Ximo's avatar
    Ximo
    Frequent Visitor
    4 years ago

    Yeap... unfortunately this seems to be pretty impossible at the moment, unless the default slicer visual is updated with the option to hide blanks, there are some UserVoice posts already on this.

     

    I thought that if it was possible to hide blanks on a matrix table with the ISINSCOPE approach (Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)) maybe there was a possibility for the slicer, but not working so far.

     

    Thanks again!