Forum Discussion
Dunner2020
Post Prodigy
Post ProdigySorting month order in line chart
Hi there, I have a date table that contains the date from January 2019 to March 2025. The structure of the table looks like following: I created the date column using following code: ...
hi Dunner2020
In edit queries, add a costom column as below:
if [Month Of Year]>=4 then ([Year]*100)+[Month Of Year]-3 else ([Year]-1)*100+[Month Of Year]+9Now use this custom column to sort by column
Result:
and here is sample pbix file, please try it.
Regards,
Lin
Dunner2020Post Prodigy
Post Prodigyamitchandak , I created a new sort column as you mentioned in the reply. It sort out the values in data view as shown in the picture:
However, it did not sort out the order of Month in line chart as shown in the picture:
v-lili6-msft
Community Support
Community Supporthi Dunner2020
In edit queries, add a costom column as below:
if [Month Of Year]>=4 then ([Year]*100)+[Month Of Year]-3 else ([Year]-1)*100+[Month Of Year]+9
Now use this custom column to sort by column
Result:
and here is sample pbix file, please try it.
Regards,
Lin