SOLVED

Slicer

Copper Contributor

Hi, can you advice me why does the Pivot table slicer shows greater , lesser than. 

How do i remove this ? 

Kechan152_0-1657944512209.png

 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

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

Riny_van_Eekelen_0-1657945349804.png

 

it works ! Thank you so much Eekelen ! :)
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

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

Riny_van_Eekelen_0-1657945349804.png

 

View solution in original post