Forum Discussion
Making the x-axis labels into a timeline
We wish to create a visualization which distributes costs according to the month the costs were paid.
Thus, I have created a visualization where the x-axis is the date (created as a hierarchy) and the values are the amount of costs.
The problem is that, the visualization only distributes the costs on a timeline, when the year is the x-axis. When i enter a deeper level of the date hierarchy, the visualization will show the months as if the data is to be shown from january to december. However, if i filter data e.g. from August 2018 to February 2019, the visualization will still be from january to december. Instead of this, i would like the visualization to be as followed: August, September, October, November, December, January, February. How do i solve this?
Hi Anonymous,
Based on my test, it looks like such a requirement is not achievable. As a workaround, you could click the third "Drill Down" button to drill down to "Year-Quarter-Month" level.
Best regards,
Yuliana Gu
3 Replies
- Greg_Deckler
Community Champion
So, to get a custom sort order, you need to create a column that has a sort the way you want it and choose your original column and do a Sort By your other column. So, for example, if you have a column:
January
February
March
April
May
June
July
And you wanted a sort order like July - January you would create a column that was 7,6,5,4,3,2,1 for those months. You would set the Sort By of the original month column to your new numeric column.
v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Based on my test, it looks like such a requirement is not achievable. As a workaround, you could click the third "Drill Down" button to drill down to "Year-Quarter-Month" level.
Best regards,
Yuliana Gu
