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
Highlighted
LivioLanzo Super Contributor
Super Contributor

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
Highlighted
LivioLanzo Super Contributor
Super Contributor

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!  

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

LivioLanzo Super Contributor
Super Contributor

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!  

v-danhe-msft Super Contributor
Super Contributor

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.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 152 members 2,247 guests
Please welcome our newest community members: