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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Employee
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
Employee
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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors