https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Remove-empty-hirearchy-levels/m-p/1091582#M3171 <P>HI! Im trying to build a custom Matrix from a table, so that the empty hierarchy levels do not display.&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Category 1</TD><TD>Category 2</TD><TD>Category 3</TD><TD>Value</TD></TR><TR><TD>BMW</TD><TD>Black</TD><TD>New</TD><TD>1</TD></TR><TR><TD>BMW</TD><TD>White</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Audi</TD><TD>Red</TD><TD>Used</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What Im betting now for the second row is&nbsp;</P><P>- BMW-White-<STRONG>BLANK</STRONG>-2</P><P>&nbsp;</P><P>How could I remove the blanks in between from the hierarchies?&nbsp;</P><P>&nbsp;</P><P>Thanks for the help!</P> Fri, 15 May 2020 13:03:32 GMT JP_Helsinki 2020-05-15T13:03:32Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Remove-empty-hirearchy-levels/m-p/1091582#M3171 <P>HI! Im trying to build a custom Matrix from a table, so that the empty hierarchy levels do not display.&nbsp;</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD>Category 1</TD><TD>Category 2</TD><TD>Category 3</TD><TD>Value</TD></TR><TR><TD>BMW</TD><TD>Black</TD><TD>New</TD><TD>1</TD></TR><TR><TD>BMW</TD><TD>White</TD><TD>&nbsp;</TD><TD>2</TD></TR><TR><TD>Audi</TD><TD>Red</TD><TD>Used</TD><TD>2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What Im betting now for the second row is&nbsp;</P><P>- BMW-White-<STRONG>BLANK</STRONG>-2</P><P>&nbsp;</P><P>How could I remove the blanks in between from the hierarchies?&nbsp;</P><P>&nbsp;</P><P>Thanks for the help!</P> Fri, 15 May 2020 13:03:32 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Remove-empty-hirearchy-levels/m-p/1091582#M3171 JP_Helsinki 2020-05-15T13:03:32Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Remove-empty-hirearchy-levels/m-p/1092345#M3172 <P>Hi <a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/231155">@JP_Helsinki</a>,</P> <P>The design pattern you're looking for is a ragged hierarchy, and Power BI doesn't support it natively. It can be managed with a number of additional modelaling changes and some measures to check which level of the hierarchy a value is on.</P> <P>The following articles are my go-tos whenever I need to implement such a pattern, and should help you out:</P> <UL> <LI><A href="https://www.daxpatterns.com/parent-child-hierarchies/" target="_self">SQLBI: Parent-Child Hierarchies</A>&nbsp;</LI> <LI><A href="https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/" target="_self">Kasper on BI: Use IsInScope to get the right hierarchy level in DAX</A>&nbsp;</LI> <LI><A href="https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual" target="_self">RADACAD: Removing Blanks from Organizational Ragged Hierarchy in Power BI Matrix Visual</A>&nbsp;</LI> </UL> <P>Good luck <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>Daniel</P> Fri, 15 May 2020 23:06:19 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Remove-empty-hirearchy-levels/m-p/1092345#M3172 dm-p 2020-05-15T23:06:19Z