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.
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
Thanks, I am unable to change this to a date field due to the text in the columns but is there a way to do this in PowerBi as the original table has Jan 2017 Units and Jan 2017 Value so there would be duplicate value otherwise. If that makes sense?
Yes, all this can be done in the edit queries area of Power BI.