Forum Discussion
AdministratorDo not add duplicate values in chart
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.
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.
3 Replies
- PijushRoy
Community Champion
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_AdminGood, 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.
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.
