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, 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.
Thanks, so I have duplicated the table (will this automatically update as the original is refreshed?). Now the visuals look like this, what am I doing wrong?
Correct, it will automatically update as the original is refreshed.
What is wrong now is that your attribute column is a text field, when it needs to be a date field. You will need to remove the word units from each row (again this can be done in edit queries), and the dates Jan 2017, Feb 2017 etc need to be converted to a date e.g. 01/01/2017, 01/02/2017