Forum Discussion

mstefancik's avatar
mstefancik
Advocate IV
11 years ago

Too many values

Hi, I am building simple column chart which represents sold items by stores. We have 171 stores. I supposed to get 171 columns to see sales of every single store. After creation there is yellow tria...
Need Help
WillT's avatar
WillT
Community Admin
10 years ago
Hi everyone. You're running into data point limits that exist to make sure performance isn't impacted. We're aware that there are problems with some sparse datasets, and are working to fix it. We plan to get to a point where you can load charts with many more datapoints, even millions in many cases. Stay tuned for updates in the new year where we'll start to ship improvements to this. Thanks for you patience!
joaod82's avatar
joaod82
New Member
9 years ago

Hi, WillT

 

Is there any advance in that topic? I tried to use the gantt chart today (august-2017) and I am getting the same message (too many values). What I think it's impressive is that my data is not too big... I have something around 25k registries only...

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi,

    I'm falling into this same problem too - and the big, big issue is that the data plotted is incorrect (incomplete). And it is way worse to plot incorrect data than no data at all...

     

    In my case, it is a simple stacked graph. X-axis has about 20 categories, and legend has 85 values. Most of them only apply to one or two categories, and their size varies, so each category has about 4-5 significant legends and a bunch of less important ones. 

     

    The graph renders, with the too many values warning... and renders wrong! What I am adding up is revenue, and quite some revenue is missing - the right-most categories don't show revenues!. That is a definite no-go.... it is increadibly wrong, and only a small warning sign is shown. That's a no-go for mass consumption of the reports....

     

    It really is not important to have a big legends-entry (colors are only useful to differentiate categories, and hovering over them gives the category name, so that's ok). And grouping the categories to have less it not ideal, because it limites the usefulness of drilling down...

     

    Please, PowerBI team, I hope you fix this soon! 

     

    Thanks!