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.

FarhanAhmed's avatar
FarhanAhmed
Community Champion
4 years ago

This should work.

 

Make sure that you don't have any trailing or leading spaces in your data.

Try Trim before applying this step.

tuncay's avatar
tuncay
Helper III
4 years ago

Trimmed month column. Still showing the numbers: 15, 14, 1 only 😞

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    4 years ago

    is it possible for you to share the PBIX file after removing sensitive data

    • 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