Re-order graphic by date (month and year)

[Aydeedglz]

Hi, I have two graphics that I want to reorder but I don't have sucess 

This is the first one: The data in the table is by order but I don't see it in the graphic

The second one And the data is also sorted 

[Aydeedglz · Accepted solution]

I solved it, if anyone needs it 

1.Create a column with DATE FORMAT and sorte it by date

2. Eliminate Hierarchy from the visual 

https://community.powerbi.com/t5/Desktop/How-to-remove-Date-Hierarchy/m-p/647894#M310625

And it is done, use it in your X-axis

[v-tangjie-msft]

Hi @Aydeedglz ,

According to your description, here are my steps you can follow as a solution.

(1)Click "Transform Data" to enter the Power Query editor, and click Add Index Column from 1.

(2)Click "Close and Apply", go back to desktop, switch to "Data" view, click to sort columns, and select index columns.

(3)Then the result is as follows.

Please refer to the following document for more information.

Sort one column by another column in Power BI - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[danextian]

Hi @Aydeedglz ,

You can create a custom column to sort the month and year column by

MoYr =
'Table'[Year] & FORMAT ( 'Table'[Month Number], "00" )

If you have a date column

MoYr =
 FORMAT ( 'Table'[Date], "YYYYMM" )

This will create a calculated column of YYYYMM format

[Aydeedglz]

I am having trouble with the FORMAT function