Slicer On Multiple Values In One Column

Hi Ashish_Mathur, 

I have built my visuals based on this method in a test file. It seems the data has duplicated if the name appears twice or more - I thought this may happen. Please see below screenshots. 

Do you think there is a way to do this without the data duplicating? 

Correct numbers:

Number after the column was split by rows: 

Row split by comma > rows:

As you can see the first entry is duplicated 3 x - my visuals have captured this 3 x which is inaccurate. 

Slicer looks good but affects visuals: 

Thank you, 

Christiana

Hi,

Share the download link of your PBI file and show the expected result with an explanation.

Hi Ashish_Mathur, 

Below is the link to the test file: 

https://drive.google.com/file/d/12f5pTnnIVfyffYj-Xp3Z5w4GWe16n0lN/view?usp=sharing

I have copied and pasted the column that was split by delimeter > comma > rows (column4) which has duplicated the rows where there was more then one name in column4. The issue is the these duplicate rows have been captured in my visuals which is inaccurate. 

Ideally, I would like:

• the sme slicer function to capture duplicate names in column4 only once. 
• the visuals to capture duplicate rows only once-that means columns 1-3 that have duplicate data should only appear in the visuals once so the value is not inaccurate. This is because there are multiple people assigned to one project. So the multiple people (column4) should appear once in the slicer however the project should only appear once in the visuals otherwise the data is inaccurate. 

I hope that makes sense. 

Please let me know if you need more info. 

Thank you.  

Access Denied message.  In that same file, show the expected result as well.

Hi Ashish_Mathur,

May I have your email? 

The expected result is what I can not figure out - to capture projects only once in the visuals so there are no duplicates. 

Thank you. 

Sorry but i cannot share my e-mail address.

I understand. There is no sensitive data and the link should work now. 

https://drive.google.com/file/d/12f5pTnnIVfyffYj-Xp3Z5w4GWe16n0lN/view?usp=sharing

Your time and help is greatly appreciated. 

Thank you. 

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