Forum Discussion
Scatter Plot missing duplicate rows
Hi all,
I'm using a measure to create a percentile chart that's dynamic based on filters. It works fine when displayed as a table, but the scatter plot visualization is removing any point with duplicate rows. However, if I add the index column to the legend field then all values are shown, but each point is a different color. How do I fix this?
6 Replies
what part needs fixing?
Hi gsmayes ,
I'm afraid it is by design.
If you remove the index from table visual, it will also remove duplicate rows.
Best Regards,
Jay
It's strange because I have a column in my data table which calculates percentile by station that was brought in from the excel data source. When I plot this the duplicate rows are shown (but doesn't dynamically recalc based on filters). So it appears this problem is only present when plotting a measure?
Also, if there was a batch way to change point color that could be a solution, but it appears I have to manually change color using the dropdown for 300+ points. FYI, I changed legend to time stamp because it's also unique and actually useful information that displays in the tooltip.
One other way to prevent involuntary grouping is to add small, inconsequential random amounts to each data point.
Hi gsmayes,
Can you share this pbix file with sample data. I shall try it with https://pbivizedit.com With this service, it should be possible to achieve what you are doing.
Thanks,
-R
PM sent
