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...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

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