Create a 'Fruit Filter' that filters the User in a pie chart.

[New_Folder]

I want to show who selected which fruits and how many time they selected it. Not shown is another column for dates.

[Anonymous]

Thanks for the reply from lbendlin and Ashish_Mathur.

Hi @New_Folder ,

I'll add to Ashish_Mathur 's answer to the effect you intended.

1.As shown in the figure, you can click on the corresponding option to split the commaed ones into a separate line.

2.Create two visual objects, the pie chart and the slicer, using user as the field for the slicer.

3.The final result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, right click on the Fruits column and select Split Column > By delimiter.  Specify the delimiter as comma and space.  Expand Advanced and select Rows.  Click on OK.  Click on Close and Apply.

Hope this helps.

[lbendlin]

You need to put in more work. Your data model needs a User reference table, a Fruits reference table, and a measure that calculates the desired value.  Put all three in a matrix visual to show the entire solution graphically without the need for slicers.