Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
bvy
Helper V
Helper V

Scatter Visual Only Shows 3500 Data Points - How to work around this?

The Scatter Visual seems to limit the number of data points it will render to 3500.

 

bvy_1-1715105842677.png

 

This is fine, but my issue is this: When I make a rectangular lasso selection in the Scatter, it only selects from the points that it decided to render. How can I expand the selection to include ALL the points in the selected region? 

 

For example, if I select a region that has 100 points, but only 30 of them are rendered in the Scatter Visual, I want the other visuals to show insights on ALL the points in that region – not just the 30 selected.

 

I wrote a measure along these lines just to count data points: 

 

Total in Region (including hidden) = CALCULATE(
   DISTINCTCOUNTNOBLANK(Table1[ID]), 
   Table1[X_img] >= MIN(Table1[X_img]) && 
   Table1[X_img] <= MAX(Table1[X_img]) && 
   Table1[Y_img] >= MIN(Table1[Y_img]) &&
   Table1[Y_img] <= MAX(Table1[Y_img])
)

 

 

bvy_0-1715106318466.png

 

 

It sort of works, but it's hit or miss when other selections are made, and I don't think it's the best way anyway. Ideally, I could capture the two opposite cornes of the selection rectangle and have those as parmaters I could use in other measures for filtering. Not sure. 

 

Can anyone help? Thanks. 

 

3 REPLIES 3
bvy
Helper V
Helper V

It is important to me and I will do that. But I still need a workaround. 

 

Anyone else? 

Consider using Drillthrough rather than lasso. Have a shadow copy of your data and display that with the delta x / delta y filters you mentioned.

 

Or use zoom sliders.

lbendlin
Super User
Super User

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.