Need some help! Clustered stacked column chart or any chart.

[shiner1]

Hello

How can I show multiple years/months of sales history in a bar line graph without Power Bi adding the months together?

Like say you want to show a range of actual sales for September 2016-September 2017 in a graph. In Excel the graph's first month would be September 2016 and end September 2017. Power Bi on the other hand only shows 12 columns for the Calendar year and adds any months selected from the previous year to the current year.

Here is an example in Excel of how it should be:

Here is how Power Bi organizes the data: It starts to add any months from the previous year together instead of the graph starting from September 2016.

Does anyone know how to solve this?

Thanks

Kyle

[shiner1]

How do I sort the months in Calendar year format instead of A-Z or Z-A? Like: Jan, Feb, Mar, April, May, June, July, Aug, Sept, Oct...

Thanks,

Kyle

[MFelix · Accepted solution]

Hi @shiner1,

Supposing you have a calendar table to do your dates in your visuals, add a column with the following code:

Month_Year = FORMAT('Calendar'[Date];"mm/yyyy")

Then use this column for your x-axis , if you want to have it on the first day of the month just change the formula to:

Month_Year = FORMAT('Calendar'[Date];"1/mm/yyyy")

(European format if needed as you have it in your chart just change the order of day/month)

Regards,

MFelix

[shiner1]

This is how it looks now: I would like to see it in Calendar order not ABC order which is what it's in now. Does anyone know how to do this?

Any help is greatly appreciated. Thanks

[shiner1]

Thanks!

How do I sort the months in Calendar year format instead of A-Z or Z-A? Like: Jan, Feb, Mar, April, May, June, July, Aug, Sept, Oct...

Thanks,

Kyle