Scatter Plot missing duplicate rows

[gsmayes]

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?

 

[radhey_rec]

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

[gsmayes]

PM sent

[v-jayw-msft]

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

[gsmayes]

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.

[lbendlin]

One other way to prevent involuntary grouping is to add small, inconsequential random amounts to each data point.

[lbendlin]

what part needs fixing?