Forum Discussion

Kechan152's avatar
Kechan152
Copper Contributor
Jul 16, 2022
Solved

Slicer

Hi, can you advice me why does the Pivot table slicer shows greater , lesser than.  How do i remove this ?   
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jul 16, 2022

    Kechan152 Select he Slicer. Then on the Slicer ribbon, select Slicer Settings and set it "Hide items with no data".

     

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jul 16, 2022

Kechan152 Select he Slicer. Then on the Slicer ribbon, select Slicer Settings and set it "Hide items with no data".

 

  • Kechan152's avatar
    Kechan152
    Copper Contributor
    Jul 16, 2022
    it works ! Thank you so much Eekelen ! 🙂

Resources