When using drill through, month is not arranged in the right order

[rickylee]

Hi,

When using drill through, month is not arranged in the right order. In my diagram, August comes first.

Possibly this is the only month with data.

The field I am using in Axis is a calendar table and the formula for that table is:

It is very odd that August comes first.

Thanks,
Ricky

[v-lili6-msft · Accepted solution]

Hi@ rickylee 

It may be you sort value descending ,for there is data in August and other months is 0, so August is in the first column like below

Best Regards,

Lin

[rickylee]

Thank you!