not able to sort order by year wise in drill down column chart

[msudulag]

Hi All,

I have the graph like below ,here i am not able to sort year wise if i go next level i can sort it like month wise or quarter wise.

how can i sort Year wise in the below graph.i have datetime field.

[msudulag]

Thanks @v-qiuyu-msft,

Its working now.

[v-qiuyu-msft · Accepted solution]

Hi @msudulag,

Please change the X axis type as Categorical, then you are able to see sort by Year button. 

Best Regards,
Qiuyun Yu