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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
kmaher
Regular Visitor

Missing Data

Hi all,

 

Ive have been loading a csv file into the datasets from my PC. The spreadsheet contains 227 columns and 44,0000 rows. However when the I try to create a line chart for some headings there is a vast amount of data missing. Ive tried refreshing and importing the data numerous times but the same values are missing everytime. When I cross checked the values with there spreadsheet there are values for those times. Any help would be appriciated.

 

Thanks in advance,

KM. 

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @kmaher ,

Based on my research, there do have some limitations for vlaues:

For any given visualization, the following visual limitations apply:

  • 3,500 is the maximum number of data points displayed on most visuals, regardless of the number of underlying data points or series (see the exceptions in the following bullet list). As such, if you have 10 series with 350 data points each, the visual has reached its maximum overall data points limit. If you have one series, it may have up to 3,500 data points if the new algorithm deems that the best sampling for the underlying data.

  • There is a maximum of 60 series for any visual. If you have more than 60 series, break up the data and create multiple visuals with 60 or fewer series each. It's good practice to use a slicer to show only segments of the data (only certain series). For example, if you're displaying all subcategories in the legend, you could use a slicer to filter by the overall category on the same report page.

The maximum number of data limits is higher for the following visual types, which are exceptions to the 3,500 data point limit:

  • 150,000 data points maximum for R visuals.
  • 30,000 data points for custom visuals.
  • 10,000 data points for scatter charts (scatter charts default to 3,500)
  • 3,500 for all other visuals

You could refer to below link:

https://docs.microsoft.com/en-us/power-bi/desktop-high-density-sampling#minimum-and-maximum-values-f...

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

Hi @kmaher ,

Based on my research, there do have some limitations for vlaues:

For any given visualization, the following visual limitations apply:

  • 3,500 is the maximum number of data points displayed on most visuals, regardless of the number of underlying data points or series (see the exceptions in the following bullet list). As such, if you have 10 series with 350 data points each, the visual has reached its maximum overall data points limit. If you have one series, it may have up to 3,500 data points if the new algorithm deems that the best sampling for the underlying data.

  • There is a maximum of 60 series for any visual. If you have more than 60 series, break up the data and create multiple visuals with 60 or fewer series each. It's good practice to use a slicer to show only segments of the data (only certain series). For example, if you're displaying all subcategories in the legend, you could use a slicer to filter by the overall category on the same report page.

The maximum number of data limits is higher for the following visual types, which are exceptions to the 3,500 data point limit:

  • 150,000 data points maximum for R visuals.
  • 30,000 data points for custom visuals.
  • 10,000 data points for scatter charts (scatter charts default to 3,500)
  • 3,500 for all other visuals

You could refer to below link:

https://docs.microsoft.com/en-us/power-bi/desktop-high-density-sampling#minimum-and-maximum-values-f...

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kmaher
Regular Visitor

Note: The data specific data missing was orginal a percentage value then changed to csv. Where ever it is a non zero value the data is left out.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.