Forum Discussion
Lasso rectangle select in line graph with overlapping data points
Well, the conclusion from Microsoft on above issue :
"What we understand as 119 data points is actually 119 series (lines) with many more data points in total—around 115,000 rows. Our system can display up to 60 series, so selection is also limited to 60 series. In reality, there are about 3,500 data points in the chart based on the series that can be shown, which is close to the data point selection limits as mentioned in the documentation: Multi-select data elements, data points, and visuals - Power BI | Microsoft Learn ."Future scope: For such cases, either the limit of datapoints recognised by the tool needs to be expanded in future releases, or provide enable/disable option for lasso select.
Hi Anonymous
To help you better, could you please provide some data or screenshots? This way I can get a better understanding of your situation. Please remove any sensitive data in advance.
The following suggestion is for your reference.
If you don't necessarily use line plots, perhaps consider using scatter plots. Then switch “High Density Sampling” to “On”.
When two or more data points overlap, the high-density sampling algorithm for scatterplots employs a method that effectively captures and represents the underlying data and eliminates the overlapping points. The radius of the circle is increased to represent these overlapping data points.
For more details, you can read related document link:
High-density scatter charts in Power BI - Power BI | Microsoft Learn
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Firstly, thank you for taking the time to explain on references!
About the above concern, changing the line graph into other visuals is not an option unfortunately as we must show in the form of trendline, but i still did try with scatter plot and settings as suggested, but it did not resolve the issue, I have tried including screenshots of graphs with dummy data.
As you see below, when there are fewer ID's included in the plot(eg: two ID's in this case), now if you try the lasso it correctly selects the data and hence the displayed count is as expected 2.
But incase we try including more number of ID's(eg: 119, which results in more overlapped lines in the visuals shown below), and try to lasso it selects only 60 of them. Unfortunately there is no option to enable/disable this feature with recent versions and older versions are not very compatible.
lasso_selected_119_ID's