cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Chart showing Month + Year in sequence

hi there,

 

just need some insight on my line and stacked column chart

 

trying to get the graph to show Month + Year in proper sequence

 

Sept 2017, Oct 2017, Nov 2017, Dec 2017, Jan 2018 and so forth

 

I have Year and Month seperated in my data already

For the chart - when I drag Year and Month into the Shared Axis column under Visualization - only one will show not both together.

 

Looking for help to see if I can some how get both to show in sequence.

 

Thank you,

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Chart showing Month + Year in sequence

@kalsonc you need to add new column in your table for sorting months correctly

 

add new column called Month Sort

 

Month Sort = FORMAT( Table[Date], "YYYY-MM" )

 

select your existing month column, go to modelling tab, select sort by column drop down, and choose month sort






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Chart showing Month + Year in sequence

@kalsonc you need to add new column in your table for sorting months correctly

 

add new column called Month Sort

 

Month Sort = FORMAT( Table[Date], "YYYY-MM" )

 

select your existing month column, go to modelling tab, select sort by column drop down, and choose month sort






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Helper IV
Helper IV

Re: Chart showing Month + Year in sequence

Hi @kalsonc ,

 

Just concatenate those (month and year) two columns using CONCATENATE and FORMAT option and use that concatented column in shared axis. I think it should work in your case. Let me know if it works or not.

 

Spoiler
monthyr = CONCATENATE(FORMAT(Sheet3[Month],0),FORMAT(Sheet3[Year],0))

Thanks,

-Arul

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors