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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
11 years ago

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.

  • mstefancik's avatar
    mstefancik
    Advocate IV
    11 years ago

    What in a case, it is not possible or I do not want to?

    • Sean's avatar
      Sean
      Community Champion
      11 years ago

      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!

      • mstefancik's avatar
        mstefancik
        Advocate IV
        11 years ago

        I counted columns manually and it is exactly 121 from 171 columns.

         

        chart.PNG

         

        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.

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      11 years ago

      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?