Slicer On Multiple Values In One Column

I do not understand anything in your file at all.  What result do you want to see?  Give a proper explanation.

Hi Ashish_Mathur, 

This file is just a snapshot of data so the logic behind the visuals may not make sense. 

1. Column 4 has been split by comma > rows. This has caused duplicate entries in my data i.e. - rows 4 and 5

rows 5 and 7
rows 11, 12 and 13

2. The visuals have obviously picked up the duplicate entries becuase column 4 have different names in the duplicate rows. The reason why I had to split column 4 by comma > rows is to consolidate the slicer fucntion so the sames do not appear twice. Below is perfect. 

3. The problem is with the consolidated slicer comes visulas that capture duplicate entries. What I am trying to achieve - automically not include any duplicate entries in the visuals whilst still capturing all the names in column 4. 

For example rows 6 and 7 should only be captured once in the visuals and the names in column 4 should appear as Marcelle A and Maree C under one entry in 'contract details' below. And at the time the slicer should remain as is. Does this make any sense? 

Thank you.

What happend when you select only Maree C in the slicer?

Hi Ashish_Mathur 

Below appears when Maree C is selected: 

So what is the problem with that result?  All looks OK to me.  Please show the expected result very clearly.

The problem is the contract value and number is doubled. 

Accurate value and number: 

Inaccurate value and number due to the splitting column 4 into comma > rows. 

You can see there are 4 more entries which is inaccurate. 

Share the download link of your PBI file.

I think I will not proceed with this feature. Thank you for all your help Ashish_Mathur 

Greatly appreciated