cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stuk Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
tringuyenminh92 New Contributor
New Contributor

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

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

6 REPLIES 6
Super User
Super User

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.
Stuk Regular Visitor
Regular Visitor

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

tringuyenminh92 New Contributor
New Contributor

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").
Stuk Regular Visitor
Regular Visitor

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 )

tringuyenminh92 New Contributor
New Contributor

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

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

Stuk Regular Visitor
Regular Visitor

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 )

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 487 members 4,446 guests
Please welcome our newest community members: