Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago
Solved

Sort by Month without date column

Hi All,   I have a table with the column called Month,   values are as:  Jan, Feb, Mar ...  Dec.  I need to sort graph by Month.    Graph is made up of  Revenue and Month.   Your help will be ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi sdhn 

    You can still sort by month by creating a 'Month Number' Index Column and sort the Month Column within the table using the 'Month Number' column. 

    If the existing table has many rows, it may affect the speed with a new column created, so if that is the case I would suggest you to create a new table and establish a relationship between the two.

    Hope this helps! If you need any clarification, feel free to reply.

     

    Please Accept this as a solution if you think I answerd your question.

    Thanks

    Mahesh 

     

  • sdhn's avatar
    sdhn
    4 years ago

    Solution:   

    We completed the following steps: 

    1. Created Month table that holds IDs for each month. 
    2. Created calculated column in the original table holding the IDs of the second table:
      MonthNumberOfYear= RELATED(Reference[Month #])

       

    3. Sorted calculated column:

       

    4. Sorted month based on calculated column:

       

    5. Refreshed visuals and confirmed changes. 
sdhn's avatar
sdhn
Responsive Resident
4 years ago

Hi Mahesh ,

 

I tried did not work as below.

 

1) I created a table sort . 

 

 I uploaded this table onto current report.

 

But currrent existing table has multiple rows for Feburay, March, April & May.  No other Months as below:

sample data

 

 

I added Month # in the existing table.  

Sample data 

 

 

 

 

here is the relationship

 

 

 

But not getting graphs correctly still.  Am I missing some thing?  Thanks