Forum Discussion

hipojoel's avatar
hipojoel
New Member
4 years ago

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...
Need Help
Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi hipojoel , Could you please share your sample data in text format(not a screenshot) with expected output. Since these calculation cant be made dynamic with custom column so I can try to find out some work around if you share sample data.

hipojoel's avatar
hipojoel
New Member
4 years ago

Here's the sample data

CustomerID,Product
1,Apples
1,Grapes
1,Oranges
1,Pears
2,Apples
2,Oranges
2,Pears
3,Apples
3,Oranges
3,Pears

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, hipojoel 

    It is basically impossible in slicer. If you want to get dynamic value, you need to consider measaure instead of calculated column. However, measure field cannot be applied to slicer. 

     

    Best Regards,
    Community Support Team _ Eason