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

Have you tried after the second option (which I suggest above) to first option.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    yes ... i tried...

    • Fsciencetech's avatar
      Fsciencetech
      Helper III
      5 years ago

      Hi Nisha,

       

      I exported this bar chart, showing me correct result as you expected