Matrix table sort column display 2019 01 instead of 2019 Jan ?

[Anonymous]

Hi All

Now my monthly date able to sort , but it display 2019 01 , may i know how to make it display 2019 Jan ?

[Anonymous · Accepted solution]

@Anonymous 

In your date table add a new column as- 

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

And use that column in your matrix.

Appreciate your kudos!! Mark this post as solution if it helps.

[Anonymous]

Hi Nikhi

I have try but still the same , not sure where go wrong ?

May be you can take a look of my PBI file :-

https://www.dropbox.com/s/mrxmp4s5mjt7eb7/SI_TDS_V011.pbix?dl=0

[Anonymous]

Hi Sir

thank you for your help