cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DomWest Regular Visitor
Regular Visitor

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.

 

Capture.PNG

 

 

 

Capture 2.PNG

 

Thanks for the help.

 

Kind regards


Dominic

2 ACCEPTED SOLUTIONS

Accepted Solutions
jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

@DomWest, have a look at this article: http://radacad.com/pivot-and-unpivot-with-power-bi, under the section 'Unpivot'

View solution in original post

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

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.

View solution in original post

17 REPLIES 17
jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

@DomWest, you would need to un-pivot the data in the query editor so all of your date columns are in 1 column.

zlokesh Member
Member

Re: Structuring Column Data by Dates in a Line Graph

Hi @DomWest,

     Put the value in AXIS  in Visualization. Will solve your problem. Thanks 

 

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Sorry, this doesn't work.

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Hi @jcarville, thanks but I am not familair with this?

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

@DomWest, have a look at this article: http://radacad.com/pivot-and-unpivot-with-power-bi, under the section 'Unpivot'

View solution in original post

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Thanks, but is there another way without transposing the data as it will change other visualisations?

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

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.

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

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?

 

Transposed.PNGVisual.PNG

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)