Data model Hierarchy - Tree slicer
I have a Data model (MS-SQL Target). I've set up a Drill Path Hierarchy for my company's org structure.
The problem I have is that it works well with double click and drill down, when in the rows/columns of a discovery. However, when I try to use it as a slicer or expand/collapse, then only the top member is available and not the "Tree" with levels which I'm expecting.
it feels like I'm missing something obvious here, so please help if you know what I'm doing wrong - thanks
If you are in 2020, change it to a "regular" hierarchy. Drill path does not offer this functionality.