Forum Discussion
Too many values
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.
What in a case, it is not possible or I do not want to?
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...
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?
