Reply
Member
Posts: 87
Registered: ‎05-25-2016
Accepted Solution

hierarchy date doubt

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,


Accepted Solutions
Frequent Visitor
Posts: 3
Registered: ‎05-06-2017

Re: hierarchy date doubt

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

View solution in original post


All Replies
Super Contributor
Posts: 670
Registered: ‎09-19-2016

Re: hierarchy date doubt

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

Member
Posts: 87
Registered: ‎05-25-2016

Re: hierarchy date doubt

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!!!

Frequent Visitor
Posts: 3
Registered: ‎05-06-2017

Re: hierarchy date doubt

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

Highlighted
Member
Posts: 87
Registered: ‎05-25-2016

Re: hierarchy date doubt

Thanks, @alexvc

 

It works!!!