Sort by Month without date column

[sdhn]

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 appreciated. 

There is not date column in the table.   Thanks 

[hmahesh94 · Accepted solution]

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 · Accepted solution]

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]

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 

[AlexisOlson]

Did you set the Month column to sort by the Month# column?

[sdhn]

No

[v-jingzhang]

Hi @sdhn 

Have you solved this problem? After sorting Month column by Month# column, it should work. Sort one column by another column in Power BI Desktop

Best Regards,
Community Support Team _ Jing

[sdhn]

see below 

[hmahesh94 · Accepted solution]

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