https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707487#M82149 <P>It's from a data model, so when you apply the visual filter it removes the other levels too</P> Wed, 17 Aug 2022 17:06:02 GMT Dev-13 2022-08-17T17:06:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707144#M82122 <P>Hi</P><P>&nbsp;</P><P>I have a slicer within my Power BI report which has a 3 field hierarchy.</P><P>&nbsp;</P><P>The 3rd field hierarchy has (blank) options which I do not want the user to see or pick.</P><P>&nbsp;</P><P>Is it possible to exclude the (blanks) from the slicer hierarchy?&nbsp;</P><P>&nbsp;</P><P>Thanks</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 17 Aug 2022 14:58:04 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707144#M82122 Dev-13 2022-08-17T14:58:04Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707362#M82139 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="427888" data-lia-user-login="Dev-13" class="lia-mention lia-mention-user">Dev-13</a> , if they are from different tables, you can have visual filter to ignore blank </P> <P>&nbsp;</P> <P>but if they are same table removing that can remove above levels too</P> Wed, 17 Aug 2022 16:13:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707362#M82139 amitchandak 2022-08-17T16:13:25Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707487#M82149 <P>It's from a data model, so when you apply the visual filter it removes the other levels too</P> Wed, 17 Aug 2022 17:06:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Slicer-Hierarchy/m-p/2707487#M82149 Dev-13 2022-08-17T17:06:02Z