Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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.
2.Drag the month into the X-axis, drag the sales into the Y-axis and drag the Region into the legend.
3.Drag the Year field into the small multiples. Set the Rows is 2 and the Columns is 1.
4.The result is shown below.
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.
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.
2.Drag the month into the X-axis, drag the sales into the Y-axis and drag the Region into the legend.
3.Drag the Year field into the small multiples. Set the Rows is 2 and the Columns is 1.
4.The result is shown below.
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.
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |