Forum Discussion
Slicer On Multiple Values In One Column
I have a table that contains a number of columns, one of which is a description. Here's a sample of the values in the description column for various rows: BLUE METAL SQUARE
RED METAL SQUARE
ORANGE C...
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.