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

Re: Structuring Column Data by Dates in a Line Graph

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?

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

Yes, all this can be done in the edit queries area of Power BI.

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Thanks, I have managed to do this but now the visual is counting the units as opposed to summing and not disinguishing by year?

 

Capture.PNG

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

To distinguish by year, make sure that the date field in your axis has date hierachy turned on (there is a small drop down arrow in the axis field under visualisations for this). This will allow you to drill by year,quarter,month etc.

 

Then to SUM instead of COUNT, it is similar to above where you access the small drop down arrow, this time in Values and change it from COUNT to SUM.

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Almost there, thank you very much. Although the Sum does not appear?Capture.PNG

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

DomWest Regular Visitor
Regular Visitor

Re: Structuring Column Data by Dates in a Line Graph

Fantastic, you have been amazing. Thank you for all your help, case closed!

jcarville Established Member
Established Member

Re: Structuring Column Data by Dates in a Line Graph

Glad to have helped.

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 140 members 1,806 guests
Please welcome our newest community members: