Forum Discussion

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago
Solved

Power BI Visual data points limitation

Dear All,

I have created a stacked column chart that shows Volume. 

X-axis- Year (ranging from 2019 to 2032)

Y-axis -Volume

Legend- Category

For each year, there are multiple categories. However, I am getting a warning message:

"Too many values. Not showing all the data. Click to see details."

Is there any workaround or method to avoid this issue?

  • I am able to do it with Deneb , I will share details with community along with Json temple for Vega lite

8 Replies

  • Hi pankajnamekar25 

    It shouldn’t normally be an issue with only ~20 points on the X-axis. The limitation is likely caused by the number of categories in the legend or by the combination of multiple categories and years, which can result in a high total number of data points.
    To understand the problem better, it would help to see your actual data structure and intended output.
    Please share a link to a cleaned PBIX file (with any sensitive data removed) hosted on a public service, so we can review the setup and suggest a proper workaround.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Hi pankajnamekar25 

    Visuals won’t render more than 3,500 data points (for stacked column charts), so when you have many years × many categories, some values get dropped.
    To work around it, you can:

    • Reduce the number of categories or years shown at once  e.g., filter to a shorter date range or top N categories.
    • Pre-aggregate data in Power Query/DAX so the visual plots fewer total points (e.g., combine smaller categories into “Other”).
    • Switch to a different visual type like Table or Matrix (they can handle more points) or a Line chart with fewer series.
    • Use slicers or drill-through so users can explore subsets instead of loading all data in one chart.

    There’s no setting to “turn off” the limit  the fix is to reduce data density or choose a visual that can handle more points.

    • v-hjannapu's avatar
      v-hjannapu
      Community Support

      Hi pankajnamekar25,
      I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

      Regards,
      Harshitha.


      • pankajnamekar25's avatar
        pankajnamekar25
        Super User

        Actually I tried these options but its not fit my requriment.

         

        If anyone achieve using Custome Visual Like Deneb or Python I am ready to explore