In matrix visualization when Taking Short month name as columns ,not able to Sort it correctly
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