Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
@Anonymous 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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Hi @Anonymous ,
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.
Thanks,
-Arul
@Anonymous 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
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |