cant sort by year month column - Can we create a measure for sorting

[Anonymous]

I was working on a pbi report where data source is Cube. When i create a chart and sort by month and year column(Data format is string) it not coming correctly (As attached). can we create a meaure on PBI for sorting this 

[Daviejoe · Accepted solution]

I have a column which gives me the month number and then i create another column and use the below to sort the month & year

Month Year Short Index =

('Date'[Year] * 100) + 'Date'[Month No.]

[Daviejoe · Accepted solution]

I have a column which gives me the month number and then i create another column and use the below to sort the month & year

Month Year Short Index =

('Date'[Year] * 100) + 'Date'[Month No.]

[amitchandak]

@Anonymous , No you need column. Please check  if creation on the column is allowed

If you have month year in the format

Month Year = FORMAT([Date],"mmm-yyyy")

you need a sort column like this
Month Year sort = FORMAT([Date],"yyyymm")

follow steps

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak

I tried to chnages the format but still it not resolved.

FORMAT(FactPortfolio[DateKey],YYYYmmm)

[Daviejoe]

Let me know if you try my method @Anonymous 

[Anonymous]

@Daviejoe 

I tried this way aswell, Same result. Thanks A lot . Really helped me 

[Daviejoe]

@Anonymous Happy to help.

[amitchandak · Accepted solution]

@Anonymous , Only two M

FORMAT(FactPortfolio[DateKey],"YYYYmm")

And made this sort column no need to use in visual. In visual you can use your old column

refer

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak 

yes its working now. Thanks a lot.