Forum Discussion
Structuring Column Data by Dates in a Line Graph
Anonymous, have a look at this article: http://radacad.com/pivot-and-unpivot-with-power-bi, under the section 'Unpivot'
To me that would suggest that the data type for Units Shipped is Text and not Decimal/Whole Number etc. This can be checked by clicking on Units Shipped and under Modeling on the top ribbon there is a data type option.
Anonymous, you would need to un-pivot the data in the query editor so all of your date columns are in 1 column.
Hi jcarville, thanks but I am not familair with this?
Anonymous, have a look at this article: http://radacad.com/pivot-and-unpivot-with-power-bi, under the section 'Unpivot'
Thanks, but is there another way without transposing the data as it will change other visualisations?
You can duplicate the table and un-pivot the data in that table. To do this, you can dupliate the table in the Edit Queries menu.