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.

     

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!