Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 hierarchy step by step. However, my actual visualization should be done in DirectQuery Mode and the PATH function is not supported in DirectQuery. Does anyone know of a way to do a ragged hierarchy in Direct Query? For the moment, it either gives me the same "child value" for Parents that don't have childs, or displays an empty line below the childless Parents.
Thanks!
Solved! Go to Solution.
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!
Hello @lglglg_ ,
If your trying to build a matrix visualization in PBI with ragged hierarchies, you may also want to try formatting your matrix to have the expand, "+", icon to drill down on each row level. having the expand button will let display only the parents and children you want to show. In this way, you can prevent showing blank or repeating children for any given parent.
To get the expand icon on your rows, go to the formatting paintbrush, and search "+". the '+/- icons' should appear. turn this option on.
Hope this helps, Power on!
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
Unfortunately, I cannot use the mixed mode for my work as my organization requires the use of DirectQuery for security purposes.
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_ ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |