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. Ho...
Need Help
  • pankajnamekar25's avatar
    pankajnamekar25
    1 year ago

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

rohit1991's avatar
rohit1991
Super User
1 year ago

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
    1 year ago

    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
      1 year ago

      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

      • v-hjannapu's avatar
        v-hjannapu
        Community Support
        1 year ago

        Hi pankajnamekar25,

        Thanks for your update. you are correct, the normal stacked column chart has a hard limit around 3,500 data points, so that’s why the issue is coming even if you already tried filtering and aggregation.

        Since those options are not working for your case, yes you can go for custom visuals.
         In Deneb visual gives you more flexibility because you can design your own chart using Vega/Vega-Lite. It takes a little learning but it can handle such cases better than the default visuals.
        In Python/R visuals  also possible, but here the chart is shown as an image inside Power BI, so some interactivity like tooltips, cross-filtering will not work like in native visuals.

        If you are open to trying, I would suggest starting with Deneb since it integrates well with Power BI and has many examples available. You can download it from AppSource and try with your dataset.

        Hope this helps if you have any queries we are  happy to assist you further.
        Best Regards,
        Harshitha.