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
hipojoel's avatar
hipojoel
New Member
4 years ago

Thank you for the response.

Now for the tricky part.

The image below shows the fruit Product are then filtered by Customer ID and now the Filter Pane shows the count for each type of fruits changed.

How can I get the number change to show the same count in the Filter Pane, so it would show as

Apples (1)

Grapres (1)

Oranges (1)

Pears (1)

So the count will dynamically changed based on the filtered Customer ID 

  • 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