Group Bar chart showing week on week together

[Steve123]

I have data from the previous 2 weeks. It's a count of boxes with an amount of things in.

I can put it in a matrix so the count of boxes with 1 thing in for week 6 is next to that for week 7, so I can easily compare:

I would like to show this in a bar chart, but have the counts boxes with 1 thing for week 6 in one colour and count for boxes with 1 thing for week 7 in another colour and have them next to each other.

If I use Stacked Column Chart I get week 6 first and then week 7:

Is it possible to achieve what I want? It feels like it should be, but I can't figure it out and can't figure out what to search for online.

[v-tangjie-msft · Accepted solution]

Hi @Steve123 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) Use the Stacked Column Chart visual to place the fields as shown in the following image.

Best Regards,

Neeko Tang

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

[Idrissshatila]

Hello @Steve123 , try using this visual

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos👍

Follow me on Linkedin

[Steve123]

Thanks for the quick reply. I've tried that and it's still showing the 2 weeks, one after the other:

What I'd like to show is the two weeks "superimposed", so the column for "1" would have two counts, one for week 6 in blue and one for week 7 in red (colours not important as long as they're different for each week)