Do not add duplicate values in chart

[Syndicate_Admin]

Good, I am working on a project and I have the doubt with duplicate values.

In my documents I have many duplicate values, but I do not want to delete them, despite being duplicates they are different players who have the same name.

I give an example and add image:

When I put a table there is no problem since they appear separately, but when I put a bar chart it adds the value of all three.

Is there a way that the chart will also come out separately its values?

Or the only solution is to change the data in the source document and not have duplicate values?

Thanks a lot.

[Anonymous · Accepted solution]

Hi @Syndicate_Admin ,

Could you please tell me which value you want to display on the visual?

How about try to use legend.A legend is a tool to help explain a graph. You are most commonly going to want to add one to a bar chart where you have several data series. You'll also want to add one to a line or scatter plot when you have more than one series. Essentially you use a legend to help make a complicated plot more understandable.

Before adding value to legend:

Later adding value to legend:

If I have misunderstood your meaning, please provide your desired output with more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @Syndicate_Admin 

Please convert chart to Infographic chart and in the color logic section, use color as per 2nd level as show in table view.
Can you share pbix after removing sensetive information?

If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[Syndicate_Admin]

Good, even making the graphic with infographic designer, the duplicates continue to be added.

I put image

.

Something I can't understand or do it correctly.