cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
warnera Frequent Visitor
Frequent Visitor

Comparing cost data for multiple years on one line graph

Having trouble figuring out how to compare mutiple years of cost data on one Jan-Dec line graph. I was thinking this configuration would get me what I am looking for....but it give me a cont. x-axis.

 

Can anyone help?question.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Comparing cost data for multiple years on one line graph

Try using the month name on the x Axis. Or you can also use the custom visual called 'Small Multiples Line Chart' which is even better in this case so you dont get a spaghetti chart

 

 

2018-12-10_9-23-56.jpg

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

4 REPLIES 4
Super User
Super User

Re: Comparing cost data for multiple years on one line graph

Try using the month name on the x Axis. Or you can also use the custom visual called 'Small Multiples Line Chart' which is even better in this case so you dont get a spaghetti chart

 

 

2018-12-10_9-23-56.jpg

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Highlighted
warnera Frequent Visitor
Frequent Visitor

Re: Comparing cost data for multiple years on one line graph

can you clarify how you have the months formatted in your table? I followed a tutorial to make a dDate table and my Jan-Dec is formatted as text only. If I try to change the date type to date, I get an error. Thanks

Super User
Super User

Re: Comparing cost data for multiple years on one line graph

Hi @warnera

 

the month is formatted as text. This is the Month column of the usual AdventureWorks Data Warehouse

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Community Support Team
Community Support Team

Re: Comparing cost data for multiple years on one line graph

Hi @warnera,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.