Forum Discussion
Sort by Month without date column
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.
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
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
