Combine multiple collums into timeline / Play Axis

[cmplieger]

Hello,

I have a table organised like this:

Services	January 2016	February 2016	March 2016
Service 1	300	400	450
Service 2	350	600	500

How can I get a timeline of the rows that automatically goes through the value of each collumn using the play axis or timeline slicer?

I see no way to do this without reorganizing my data to have a date collumn specifically.

Thank you for your help.

[v-yuezhe-msft]

Hi @cmplieger,

Agree with LaurentCouartou . Timeline slicer requires Date type field.

In your scenario, you can select the three columns (January 2016, February 2016 and March 2016), select Unpivot columns in Query Editor, then replace these values(January 2016, February 2016, March 2016) with appropriate Date type values as shown in the second screenshot.  This way,  you are able to drag the Date field(Attribute column in my example) into Timeline slicer.



Thanks,
Lydia Zhang

[LaurentCouartou · Accepted solution]

In this case, reorganizing your data to have a date column specifically is strongly recommended.

You can do this pretty easily with the Unpivot operation in the query editor, and it will really make your life easier.

[cmplieger]

Thanks to you both. I have changed my data structure and things are much easier now!