https://community.fabric.microsoft.com/t5/Developer/Slicers-on-Matrices-with-Hierarchy/m-p/3432351#M44461 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="615564" data-lia-user-login="Wi-fi" class="lia-mention lia-mention-user">Wi-fi</a>,</P> <P>Current power bi does not support only show the specific level of hierarchy fields.</P> <P>You can create an unconnected table with category values and write a measure formula to compare with current items and selections to return flag.</P> <P>After these steps, you can use it on visual level filter to filter records.</P> <P><A href="https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/" target="_blank">Clever Hierarchy Handling in DAX - SQLBI</A></P> <P><A href="https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/" target="_blank">Applying a measure filter in Power BI - SQLBI</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Fri, 15 Sep 2023 05:51:32 GMT Anonymous 2023-09-15T05:51:32Z https://community.fabric.microsoft.com/t5/Developer/Slicers-on-Matrices-with-Hierarchy/m-p/3425343#M44394 <P><img /><BR /><BR />I have a matrix with row headers with sub categories. Is there a way to use slicers/filters to veiw the subcategories? For example, If I click Heartland on the slicer, I want it to show all of the subcategories only.</P> Tue, 12 Sep 2023 02:17:55 GMT https://community.fabric.microsoft.com/t5/Developer/Slicers-on-Matrices-with-Hierarchy/m-p/3425343#M44394 Wi-fi 2023-09-12T02:17:55Z https://community.fabric.microsoft.com/t5/Developer/Slicers-on-Matrices-with-Hierarchy/m-p/3432351#M44461 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="615564" data-lia-user-login="Wi-fi" class="lia-mention lia-mention-user">Wi-fi</a>,</P> <P>Current power bi does not support only show the specific level of hierarchy fields.</P> <P>You can create an unconnected table with category values and write a measure formula to compare with current items and selections to return flag.</P> <P>After these steps, you can use it on visual level filter to filter records.</P> <P><A href="https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/" target="_blank">Clever Hierarchy Handling in DAX - SQLBI</A></P> <P><A href="https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/" target="_blank">Applying a measure filter in Power BI - SQLBI</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Fri, 15 Sep 2023 05:51:32 GMT https://community.fabric.microsoft.com/t5/Developer/Slicers-on-Matrices-with-Hierarchy/m-p/3432351#M44461 Anonymous 2023-09-15T05:51:32Z