Forum Discussion

kmaher's avatar
kmaher
Regular Visitor
7 years ago
Solved

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...
  • v-danhe-msft's avatar
    7 years ago

    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-for-high-density-line-visuals

     

    Regards,

    Daniel He