yearly sorting issue...

[Anonymous]

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?

[Anonymous · Accepted solution]

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]

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

[Fsciencetech]

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

[Anonymous]

here am sharing url of my pbx file...plse go through it..https://www.dropbox.com/s/ep5d2o0bpi9npaa/ratechange.pbix?dl=0

[Fsciencetech]

Hi Nisha,

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

[Anonymous]

yes ... i tried...

[Fsciencetech]

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]

still facing same issue....