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....Plse help?

 

 

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...

8 Replies

  • 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....

  • 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

    i have still issue in power bi service after publishing these to a particualr account

  • Anonymous's avatar
    Anonymous
    Not applicable
    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...