Forum Discussion
Help Formatting Bar Chart
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , Are you looking for clustered stacked visual https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200001934?tab=overview
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
