Sorting order for yearly having issue after exporting from power bi service

[NISHA_S]

Hi all....

       Here showing 2 graph with yearly axis values ..In report, graph  is showing correct sorting order while opening in power bi desktop and data exported directly in desktop...But am facing issue in power bi service ...ie...after publishing these report in powe rbi service account and i tried to export that data...while opening in excel yearly sorting order is incorrect...Here sharing pbx file below..plse help

https://www.dropbox.com/s/ep5d2o0bpi9npaa/ratechange.pbix?dl=0

[NISHA_S · Accepted solution]

At last i 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...

[RJ251997]

Hi @NISHA_S 

While exporting it shows sorting in the same order as it is in the report.
You can add filters of sorting and then try to export it.

Thank

Rohit