Forum Discussion
Combine multiple collums into timeline / Play Axis
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.
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.
3 Replies
LaurentCouartouSolution Supplier
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.
Thanks to you both. I have changed my data structure and things are much easier now!
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
