How to show a line graph by month

[Anonymous]

Hello there, 
I making a line graph to show sales of 2018 and 2019. I created a date table and I related this to dates in sales table.

I want the graph looks like this

But when I put date in the axis it looks like this 

I put a column in the date table of months, year and days but in the case of January it sums january of 2018 and 2019

Hope you can help me.

Thank you. 

[Anonymous]

Dear All

Good Day

I am having the Same issue 

I am having a Data table As below of Weeks & values (in terms of Weekly Value & Accumalative Value),( I am Plotting the **bleep** Columns Column No.7,8,9

When i use a Line Graph it is shown like Below (Which is what i need) but remaining is to show the rest of the Months (Like Feb,April, Aug,ETC)

I Have Formated the weeks to show me Month & year only using this fromula 

Date (MY) = FORMAT([Date], "MMMYY") but the graph is shown like this (The Numbers has been Accumalated)

 Kindly I need your Support

[Greg_Deckler]

Try changing the x-axis setting from Continuous to Categorical in the Format pane.

[Anonymous]

I tried what you say but it shows me every day of the calendar, and if I put months on the axis box I have the same problem in January that sums sales of january 2019 and 2018.

[Greg_Deckler · Accepted solution]

Put the date hierarchy in instead of the date and choose a hierarchy of year and month and drill down into it to the month. With Categorical turned on.