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 triangle with exclamation mark in the upper left corner of the chart. After clicking on it I see this Message:
Why do I get this error? I mean 171 is quite normaln as you have slider at the bottom of the chart. Yes I can filter stores by some category. But on the top level, ct wants to see all the stores as you can see in excel pivot table not saying you can do it in any other visualization tool such as Datawatch, Qlikview...
PowerBI should handle it.
Is there any limitation on the columns, chart can presents?
I'd like to chime in on this topic as well. For me it doesn't appear to be an issue with a visual, but with the data itself. I have a a one-to-many join between a DateDimension table and HeadCounts table, as well as a Contributions table. DateDimension contains columns for FiscalYear:
FiscalYear = CONCATENATE("FY-", IF(MONTH(DateDimension[DateKey])<=8,VALUE(FORMAT(DateDimension[DateKey], "YYYY")),VALUE(FORMAT(DateDimension[DateKey],"YYYY"))+1))
FiscalMonth = SWITCH ( TRUE(), MONTH(DATEVALUE(DateDimension[DateKey])) = 1, "05-Jan", MONTH(DATEVALUE(DateDimension[DateKey])) = 2, "06-Feb", MONTH(DATEVALUE(DateDimension[DateKey])) = 3, "07-Mar", MONTH(DATEVALUE(DateDimension[DateKey])) = 4, "08-Apr", MONTH(DATEVALUE(DateDimension[DateKey])) = 5, "09-May", MONTH(DATEVALUE(DateDimension[DateKey])) = 6, "10-Jun", MONTH(DATEVALUE(DateDimension[DateKey])) = 7, "11-Jul", MONTH(DATEVALUE(DateDimension[DateKey])) = 8, "12-Aug", MONTH(DATEVALUE(DateDimension[DateKey])) = 9, "01-Sep", MONTH(DATEVALUE(DateDimension[DateKey])) = 10, "02-Oct", MONTH(DATEVALUE(DateDimension[DateKey])) = 11, "03-Nov", MONTH(DATEVALUE(DateDimension[DateKey])) = 12, "04-Dec")
At one point the error was indicating that PowerBI couldn't perform the function on varchar data types, so I added the DateValue function to the formula...to no avail.
Overall, there are over 800K records, but only approximately 1,000 that are not displaying the Fiscal info...the remaining rows display the info as desired.
Here's the error associated with the above table:
Any positive input towards a solution is greatly appreciated!
Hello Power BI team, can I get some clarification what this message really means?
Some people report that it is only an issue on the desktop tool and uploading report to PowerBI site resolves. However, that doesn't work for me.
Others as in this thread above suggest data should be transformed into groups in order for PowerBI to be able to present it. Frankly this is not something that I expect is a requirement. I experience the "Too many values" message with record sets that are not what would be considered "too big" on any other BI solution including Excel pivot tables, Power Pivot, etc.
I am using latest PowerBI desktop tool and a license free PowerBI with my Office365 E3 account.
What is really happening here?
* is it a Desktop tool limitation?
* is it something that happens in specific situations?
* is it a free PowerBI account limitation?
* is PowerBI just a limited capability BI solution?
* is this something that will be resolved or upgraded in future?
I really like what i see witih Power BI so far but this is a severe limitation for a modern BI solution.
Looking forward to your reply!!
WillT wrote on 12-22-2015: "We're aware that there are problems with some sparse datasets, and are working to fix it."
It is now July 25, 2018, more than three years later, and I'm still running into this "Too many values" limitation. Please fix it.
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...
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!
It's a chore but it happens even if you have some data too small to be rendered
Try put that on a pie and the yellow signal appears. But "too many values" is a misleading information. And i can be OK with not be able to see c's slice. I'd really like to be able to remove that warning
I would suggest, if possible, to pivot your data so that stores are in rows and your metrics are in columns. Then you should not run into this.
I created 200 columns in a CSV file anded add all of the column to a table that I then switched to a column chart and clustered column chart. Never received a yellow warning indicator. Did you get this in Power BI Desktop or the service?
171 Columns in a Column chart is not a problem at all - you should just have to scroll to the right to see all
Can you list all relevant columns you have in the table you use for the column chart?
Something like => Store#, Sales, Etc... => And tell us which do you use to build the chart?
I actually get a similar message in a pie chart when few slices are simply too small compared to the rest to show their data labels!
I counted columns manually and it is exactly 121 from 171 columns.
Yes I can order them ascending and then descending and see both outline values, but I want to figure out how to get the full picture.
All the caharts are created in PowerBI desktop version.
Can you post a picture of your chart fields and positions, what is your axis, etc. The definition portion of the chart. I'm not sure my test was the same as yours because the charts are different. I, literally, chose 200 columns individually to show up on my chart, which was waaaaayyyy painful...
This is becoming a large problem as we roll out PowerBI.Com in my firm.
This error is causing a trust issue with my users. Using the same Tabular models, same data, same filters - they never got this error in SharePoint PowerView.
Note my example. The error says that "too many month-year" values... But, it's filtered for 2015. It can't possibly be too many months for one chart. Data has been removed from this visual - it's essentialy lying at this point. Though, oddly enough it's the legend-value that is the problem.
I hope this is being fixed. It's becoming a big issue for my users that are PowerView pros wanting to make the transition to PowerBI.com.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.