In matrix visualization when Taking Short month name as columns ,not able to Sort it correctly

[Anonymous]

Hi Power Bi Family,

I have Created a Matrix Visulization in that i need to get jan to dec as my columns (Short Names) when I created a column as Short_name=FORMAT([Date],"mmm") then when i used i am geetting as either (A to Z or Z to A),

Again i created Month_number Column =MONTH([date]) i got month numbers ,

Now When ever i sort them they are not working which as i deserved.

Please find the scrrenshots:

created two columns data type text,whole numbersIn data view sort by Month numberBy clicking this tile i am not getting anything in Sort by tab

Thanks in advance.

[Mariusz]

Hi @Anonymous 

Have you sort by your Month Column?

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Hi @Mariusz ,

Yes i have done it,Please find the Attached...

is there any thing need to do by data types...?

 and in Report view sort column is not giving any result

[Mariusz · Accepted solution]

Hi @Anonymous 

Please make sure you select Short Month and sort it by Month Number.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Thank you so Much ,it is working fine now