cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Responsive Resident

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

There is not date column in the table.   Thanks

2 ACCEPTED SOLUTIONS
Helper I

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.

Thanks

Mahesh

Responsive Resident

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.
7 REPLIES 7
Responsive Resident

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.
Responsive Resident

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

Super User

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

Responsive Resident

No

Community Support

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

Responsive Resident

see below

Helper I

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.

Thanks

Mahesh

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors