Forum Discussion

Dev-13's avatar
Dev-13
Helper I
4 years ago
Solved

Slicer Hierarchy

Hi

 

I have a slicer within my Power BI report which has a 3 field hierarchy.

 

The 3rd field hierarchy has (blank) options which I do not want the user to see or pick.

 

Is it possible to exclude the (blanks) from the slicer hierarchy? 

 

Thanks

 

 

  • Dev-13 , if they are from different tables, you can have visual filter to ignore blank

     

    but if they are same table removing that can remove above levels too

2 Replies

  • Dev-13 , if they are from different tables, you can have visual filter to ignore blank

     

    but if they are same table removing that can remove above levels too

    • Dev-13's avatar
      Dev-13
      Helper I

      It's from a data model, so when you apply the visual filter it removes the other levels too