I could not sort bar chart by fiscal calendar by date

[PassionBIdevlpr]

Hello community,

I could not sort total sales by fiscal calendar date.Pls help how to sort.Thanks in advance.

[PassionBIdevlpr]

Hello Vahid, thanks for giving solution. I did format to whole no.Data almost sorted,but  jan to sep data has been come correctly. but oct,nov and december  sorted very last as we take format has whole number. Is there any solution to resolve the issue. fyi,data sorted as following pic.

[VahidDM]

Hi @PassionBIdevlpr 

Add a new column with this code and make sure to set the format to whole number:

Sort Month-Year = 
YEAR('Table'[Date])&MONTH('Table'[Date])

And then sort your Month-Year column with the new column:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube