https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Hierarchy-in-matrix-visual-blank-rows/m-p/4611942#M12317 <P>Hi everyone!</P><P>I have a hierarchical tree of departments and i would like the show the processes_id in each unit like that using the matrix visual.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="denis1978_0-1742150042739.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1250873iCCA40567775DC2D6/image-size/medium?v=v2&amp;px=400" role="button" title="denis1978_0-1742150042739.png" alt="denis1978_0-1742150042739.png" /></span></P><P>The strings in the format xxx-yyyy are the processes id that are in each unit. It's working amost well except the blanks rows <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> I would like to know if there is way not showing the blank rows. The option '<STRONG>Show items with no data</STRONG>' is <EM>unchecked</EM>. In 'rows' i put the four levels and the process_id. The pbix file is <A href="https://github.com/denismangia/powerbi" target="_self">here</A>!&nbsp;<BR /><BR />Thanks for any help!</P><P>&nbsp;</P> Sun, 16 Mar 2025 18:47:22 GMT denis1978 2025-03-16T18:47:22Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Hierarchy-in-matrix-visual-blank-rows/m-p/4611942#M12317 <P>Hi everyone!</P><P>I have a hierarchical tree of departments and i would like the show the processes_id in each unit like that using the matrix visual.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="denis1978_0-1742150042739.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1250873iCCA40567775DC2D6/image-size/medium?v=v2&amp;px=400" role="button" title="denis1978_0-1742150042739.png" alt="denis1978_0-1742150042739.png" /></span></P><P>The strings in the format xxx-yyyy are the processes id that are in each unit. It's working amost well except the blanks rows <span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> I would like to know if there is way not showing the blank rows. The option '<STRONG>Show items with no data</STRONG>' is <EM>unchecked</EM>. In 'rows' i put the four levels and the process_id. The pbix file is <A href="https://github.com/denismangia/powerbi" target="_self">here</A>!&nbsp;<BR /><BR />Thanks for any help!</P><P>&nbsp;</P> Sun, 16 Mar 2025 18:47:22 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Hierarchy-in-matrix-visual-blank-rows/m-p/4611942#M12317 denis1978 2025-03-16T18:47:22Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Hierarchy-in-matrix-visual-blank-rows/m-p/4612360#M12320 <P>Power BI does not support jagged hierarchies so the blanks cannot be removed.</P> Mon, 17 Mar 2025 07:42:04 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Hierarchy-in-matrix-visual-blank-rows/m-p/4612360#M12320 Deku 2025-03-17T07:42:04Z