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.
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.
Solved! Go to Solution.
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:
You could refer to below link:
Regards,
Daniel He
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:
You could refer to below link:
Regards,
Daniel He
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.