hierarchy date doubt

[Angel]

Hi, everyone

I think my question is simple. 

If I select two years, ¿is there a way using only date hierarchy to show in a continous line all months from 1 year and then the other months of other year? (x-axis).

I know I can do that using calculated column to concatenate Year+Month, but ¿is there another way?.

Thanks,

[MFelix]

Hi @Angel,

Assuming that you use a line chart the best way is to use the Month in the X-Axis and then the Year in the legend, that way you will get the two years in different lines.

Regards,

MFelix

[Angel]

Hi, @MFelix

I can't use Year in legend becuase seller name is used it.

I want to show how prices have changed across all months from 2016 to 2017.

Anyway, thanks!!!

[alexvc · Accepted solution]

Have you tried creating a hierarchy with year and month? Choose a line chart and put this hierarchy on the axis. To display what you want (year+month) in the X-Axis choose the third drill down icon on the top left of the chart ("Expand all one level in the hierarchy")

Alex

[Angel]

Thanks, @alexvc

It works!!!