Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

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

2 Replies

  • RJ251997's avatar
    RJ251997
    Icon for Helper I rankHelper I
    5 years ago

    Hi Anonymous 

     

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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