Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Snehapbidev
New Member

Stacked column chart with month on month sales growth

I have a requirement of plotting sales growth month on month for 2 years categorised by 3 regions (legend) . I am able to plot the chart , however the months columns are displayed year wise like Jan to dec for 2023 and again Jan to April for 2024( bars) . 

I want Jan 2023 and Jan 2024 sales side by side . Similarly for other months. 

How to rearrange in this manner in x axis.

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @Snehapbidev ,

First of all, many thanks to @amitchandak  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1713939973527.png

2.Drag the month into the X-axis, drag the sales into the Y-axis and drag the Region into the legend.

vjiewumsft_1-1713939990457.png

3.Drag the Year field into the small multiples. Set the Rows is 2 and the Columns is 1.

vjiewumsft_2-1713939997667.pngvjiewumsft_3-1713940004600.png

4.The result is shown below.

vjiewumsft_4-1713940015609.png

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-jiewu-msft
Community Support
Community Support

Hi @Snehapbidev ,

First of all, many thanks to @amitchandak  for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

vjiewumsft_0-1713939973527.png

2.Drag the month into the X-axis, drag the sales into the Y-axis and drag the Region into the legend.

vjiewumsft_1-1713939990457.png

3.Drag the Year field into the small multiples. Set the Rows is 2 and the Columns is 1.

vjiewumsft_2-1713939997667.pngvjiewumsft_3-1713940004600.png

4.The result is shown below.

vjiewumsft_4-1713940015609.png

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Snehapbidev for that in your visual first drag month and then year and use concatenate label off and sort on axis

 

You need to have two columns on axis , month (with a sort column month no) and year

 

It is default option these days, in case it does work

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.