Data classed by month but don't care about year

[Stuk]

Hello ! i have a problem, i created a graphics which class data by month by users but it don't care about years but i would like to only see data from the years in progress, and if you have any solutions to order month in the right way i take it too thanks

[MattAllington]

You need a calendar table that contains month names and also a month number. You can then sort the month name by the month number 

read my article here http://exceleratorbi.com.au/power-pivot-calendar-tables/

[Stuk]

Thanks to you @MattAllington i created a calendar but whatever i use it as filter it still order it in alphabetical order, and do you have any solutions for my main problem which is it's classified by month but years doesn't matter

[tringuyenminh92]

Hi @Stuk,

Choose your Month field, go to Modeling tab, choose sort by column and choose date column ( or another "order column").

[Stuk]

@tringuyenminh92 it's not working, probably because datas i'm using and calendar aren't connected ( i'm sorry for those stupid questions but i'm beginner in power bi and i don't have times to do depth study because i'm working on it for my internship )

[tringuyenminh92 · Accepted solution]

Hi ,

Nevermind about beginner or adv ^_^ we was newbie and are growing up day by day ^_^ so the idea of sort by feature in Modeling tab is you have one integer column( index/order column) and you choose Month column and choose sort by int column. This order column could be created by Add conditional column in Query editor or you could add new calculated column and if else/switch based on Month column.
More details, you could follow up calendar topic of and map relationship if you have date column in your fact table as @mat mentioned.

Or you could share your Pbix so I could quickly check it in next 1hour

[Stuk]

thanks it's all good now ! ( sorry for not answering before it was my lunch break )