Lasso rectangle select in line graph with overlapping data points

[Rxth_BK]

I have a concern on lasso/rectangle select feature availble in Power BI Service and desktop.

Here's the scenario:
There is a line graph with multiple overlapping data points/lines with zoomsliders, when we try selecting the data points on the visual with lasso select, it's selecting partially excluding the underlying datapoints. Even when zoomed to particular section, the result is in a similar way.

Example:
Suppose there are 120 datapoints in the entire line graph, when you lasso select the entire graph it shows up only 50 datapoints resulting in inaccurate display.

May I know if there's any solution(custom line graph that supports lasso, or measures etc) that can overcome this issue?

Tagging in few super users for quicker help:) 

@Idrissshatila @v-yuta-msft 

Thank you!

[Rxth_BK · Accepted solution]

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.

[Anonymous]

Hi @Rxth_BK 

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.

[Rxth_BK]

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