Forum Discussion
Structuring Column Data by Dates in a Line Graph
Hi,
When data columns are structured like the below, how can I organise them by date in a visual along the X axis? They currently will just sit in the same axis where I would like them to be by month on the X Axis.
Thanks for the help.
Kind regards
Dominic
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.
17 Replies
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'
Hi Anonymous,
Put the value in AXIS in Visualization. Will solve your problem. Thanks
