This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 15 | |
| 11 | |
| 9 | |
| 8 | |
| 6 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 15 | |
| 13 |