Sort visual by year and month

[gtamir]

Hi, I am struggling this for some time, and if it comes right it is par azar.

I want to sort the income month by month by the year and the month.

On the left table, I filtered to show only 0ne year, somehow it sorted it by month too.

I copied the table to the right it was sorted properly but 2019 first. As I sort it by year the visual is sorted by month alphabetically. 

What is the trick?

Giora

[JarroVGIT]

Are you using a date table? If not, that would do the trick with regard to the sorting by year, and then by month within that year.

If this answered your question, please mark this as the solution. Kudos are welcomed!

[gtamir]

@JarroVGIT Yes. you can see in the attached image the columns and measures involved.

[JarroVGIT]

My apologies, I didn't noticed in the opening post. In the dataview, you can select the MonthName column and pick the menu option 'Sort by' column. Then chose a column that is numbered, or for example YYMM (which would also do the trick I think). 

Did that solve your problem?

[gtamir]

I am not sure I understand you, but here it will sort alphabetically.

[v-chuncz-msft · Accepted solution]

@gtamir 

You may take a look at the posts below.

• https://community.powerbi.com/t5/Desktop/Sorting-by-Month-as-Text-Jan-Feb-Mar-etc/m-p/9237#M1728
• https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918