Power BI Visual data points limitation

[pankajnamekar25]

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?

[rohit1991]

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]

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]

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]

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.

[pankajnamekar25 · Accepted solution]

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

[v-hjannapu]

Hi @pankajnamekar25,

That’s great to hear  Really happy you could achieve it with Deneb. 
It will be very helpful for other community members if you can share the JSON template and steps whenever you are ready.

Best Regards,
Harshitha.

[v-hjannapu]

Hi @pankajnamekar25,

Happy to hear you achieved this using Deneb.
Please share the JSON template and steps when you are ready, so that other members can also benefit.

Best regards,
Harshitha.

[Ritaf1983]

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.