Making the x-axis labels into a timeline

[Anonymous]

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?

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

That seems to be the solution

Thank you for the advice

Best regards
Jonas

[Greg_Deckler]

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.