Forum Discussion
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 appreciated.
There is not date column in the table. Thanks
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
Solution:
We completed the following steps:
- Created Month table that holds IDs for each month.
- Created calculated column in the original table holding the IDs of the second table:
MonthNumberOfYear= RELATED(Reference[Month #]) - Sorted calculated column:
- Sorted month based on calculated column:
- Refreshed visuals and confirmed changes.
7 Replies
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
see below
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
Did you set the Month column to sort by the Month# column?
No
Solution:
We completed the following steps:
- Created Month table that holds IDs for each month.
- Created calculated column in the original table holding the IDs of the second table:
MonthNumberOfYear= RELATED(Reference[Month #]) - Sorted calculated column:
- Sorted month based on calculated column:
- Refreshed visuals and confirmed changes.
