Forum Discussion
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...
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!
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
Hi lglglg_ ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank