Forum Discussion
yearly sorting issue...
Hi all, yearly sorted data exported having issue..Below graph yearly axis value is sortedly dipslaying...But same data after exporting and open in excel its not showing sorted orderly.......
solved the issue .Currently i used a year column created as
year = YEAR('calendar'[Date]).I just add another new column asNew Year = FORMAT('calendar'[Date],"YYYY").Then i used these New Year and sorted these column using above year column...
solved the issue .Currently i used a year column created as
year = YEAR('calendar'[Date]).
I just add another new column as
New Year = FORMAT('calendar'[Date],"YYYY").
Then i used these New Year and sorted these column using above year column...