Forum Discussion

Advocate I

7 years ago

Solved

Ragged Hierarchy in Direct Query Mode

Hi, I have been trying to create a matrix visual containing a ragged hierarchy. I managed to get the matrix to display the way I wanted it in import mode, using the PATH function and creating the...

Need Help

Tips and Tricks

Tutorial Requests

lglglg_
7 years ago
I actually found the solution to this on another post!
See Anonymous 's solution in the link below:
https://community.powerbi.com/t5/Desktop/Ragged-hierarchy-Visualization/td-p/162892

Thanks!

v-frfei-msft

Community Support

7 years ago

Hi lglglg_ ,

As we know PATH function is not supported for use in DirectQuery mode. In your scenario, we can use mixed mode to work on it. Please check the online document as below.

https://docs.microsoft.com/en-us/power-bi/desktop-storage-mode

Regards,

Frank

lglglg_

Advocate I

7 years ago

Unfortunately, I cannot use the mixed mode for my work as my organization requires the use of DirectQuery for security purposes.

lglglg_
Advocate I
7 years ago
I actually found the solution to this on another post!
See Anonymous 's solution in the link below:
https://community.powerbi.com/t5/Desktop/Ragged-hierarchy-Visualization/td-p/162892

Thanks!

Forum Discussion

Ragged Hierarchy in Direct Query Mode

Related content

Ragged Hierarchy?

Request: Support for Ragged Hierarchies

Ragged Hierarchy no aggregation

Having issue with Ragged hierarchy in matrix visualization

Ragged Hierarchy in a Matrix