Reply
Frequent Visitor
Posts: 4
Registered: ‎11-29-2018

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

Highlighted
New Contributor
Posts: 643
Registered: ‎09-16-2018

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

Frequent Visitor
Posts: 4
Registered: ‎11-29-2018

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

New Contributor
Posts: 643
Registered: ‎09-16-2018

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

Community Support Team
Posts: 1,746
Registered: ‎06-24-2018

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.