Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.......
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    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...
Fsciencetech's avatar
Fsciencetech
Helper III
5 years ago

Hi Nisha,

 

Try this one - first convert into table like below and sort it by year ascending order

then change into bar graph.

2nd option you may try -

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    still facing same issue....