Make an evolutionary graph of my sales, compared to the previous year.

[Richard3]

I need to make a graph or table where an evolutionary graph of sales is observed and that I can compare with the same month of the previous year.

Attached example image.

[williejacobs]

Hi @Richard3 

I tend to do timeline based charts on line charts, but you can do the same on a bar chart as required.

Create dimensions for month and year, add both to your chart and your measure.

[Richard3]

I need to have a timeline for example of two years with months and years where the production is seen and another line that shows me the comparison of the production against the previous year, as well as the one I place in the image, is this possible?

[williejacobs · Accepted solution]

@Richard3 

Create a "yearmonth" field for your date, I would go with "Date(MonthStart(trxdate),'MMMM yyyy')".

You can then add this yearmonth field to your chart as the dimension and you can then add 2 measures.