Help Formatting Bar Chart

[Anonymous]

Hi, 

I have the following bar chart which has 2 dimensions on the X-Axis (Week and Group). 

Is there anyway to removed the gaps, for example, Week 46 and 47 have 2 'Group' so it would be good to see this gap closed, something like this below, is that possible at all please? 

[amitchandak]

@Anonymous , Are you looking for clustered stacked visual https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview

[Anonymous]

That looks like it could work, but not sure how to build this out as I have 3 measures (Test One, Test Two and Test Three) but I can only add in one measure. I'm then not too sure what to do with Categories or Legend. 

Any Idea please? 

[Anonymous · Accepted solution]

Hi @Anonymous ,

What does your table look like? Here you create three measures Test One/Test Two/Test Three and add them in Value field in your visual. Clsuter Stacked  Bar Chart doesn't support you to add multiple measures in its value field. Clsuter Stacked  Bar Chart needs a Legend Part to distinguish Test One/Test Two/Test Three.

Your table should looks like as below.

So I suggest you to sort your visual in Stacked Column Chart by Week Group(X axis) and then turn off Cancatenate labels in X axis Format.

Best Regards,
Rico Zhou

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