Reply
Regular Visitor
Posts: 18
Registered: ‎01-06-2017
Accepted Solution

Data classed by month but don't care about year

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 thanksCapture.PNGCapture.PNG


Accepted Solutions
New Contributor
Posts: 501
Registered: ‎04-21-2016

Re: Data classed by month but don't care about year

[ Edited ]
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

View solution in original post


All Replies
Super User
Posts: 1,627
Registered: ‎07-03-2015

Re: Data classed by month but don't care about year

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/

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Regular Visitor
Posts: 18
Registered: ‎01-06-2017

Re: Data classed by month but don't care about year

Thanks to you @MattAllingtonCapture.PNG 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

New Contributor
Posts: 501
Registered: ‎04-21-2016

Re: Data classed by month but don't care about year

Hi @Stuk,

Choose your Month field, go to Modeling tab, choose sort by column and choose date column ( or another "order column").
Regular Visitor
Posts: 18
Registered: ‎01-06-2017

Re: Data classed by month but don't care about year

@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 )

New Contributor
Posts: 501
Registered: ‎04-21-2016

Re: Data classed by month but don't care about year

[ Edited ]
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
Regular Visitor
Posts: 18
Registered: ‎01-06-2017

Re: Data classed by month but don't care about year

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