Forum Discussion

tuncay's avatar
tuncay
Helper III
4 years ago
Solved

Sort the visualization by month

I have a big list of data, where I have specific data sort by month about an organizational unit. When I create a visual, I try to sort the column month by monthNum, but it says:  The Month column c...
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    4 years ago

    This is because your MonthNum has different values for Same Month 

     

    e.g. Jan has 169,183,197 etc causing issues while sorting

     

    to make this work your each text value must have the same Numeric value for sorting.

     

    Try create a calculated column to give you values 

     

    - Jan =1

    - Feb =2 

     and so on.

     

    Then apply sort by option and it will work for you.

     

    Note: This calculated column should be done in Power Query or in Data Source.

tuncay's avatar
tuncay
Helper III
4 years ago

Unfortunately, this is not possible. Maybe I could try doing something else. Any ideas?

 

 

edit: I had to add a blank space after the values 😄 (e. g.: "Jan ") works now, thank you

FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

See this file helps.

 

Also make sure that Trim, Clean is being applied also check the case sensitivity of the data itself while comparing.

 

if possible kindly share the screenshot of the calculated column like below