Forum Discussion
Slicer Value
Is there a way you can add the count in the Filter Pane as part of the Slicer Value? In the Image below, it shows the basic Slicer Value. What I am trying to do is add the count in the Filter...
Hi,can use this :
1.Build a table and connect the relationships :
Fruits = VALUES('Sheet1'[fruit])
2.Re-create columns :
Filter = 'Fruits'[fruit] & "(" & CALCULATE(COUNT(Sheet1[fruit]),ALLEXCEPT(Fruits,Fruits[fruit])) & ")"