Trying to control the increment values on a Clustered Bar Chart

[Roseventura]

I have two bar charts (below) that are showing the same information, but just by different categories (one is by

Manufacture Part, and the other is by Customer).

As you can see, the values are very similar.

My Question:    Is there a way to have the Customer bar chart show the same X axis increments as the Mfg Part increment?

Why is one broken down by 1,000, while the other goes from 0 to 5,000?

Ideally, I'd like both charts to show the X axis as this:    0   1,000   2,000   3,000   4,000   5,000

Any help would be greatly appreciated.

Rose

[fhill]

Try manually assigning both charts the same Start / End X-Axis values.

See below where the top charts are 'auto'/'auto', and in the 2nd set of charts i've manually set both charts to 6500 'End'.

[Roseventura]

Unfortunately, that didn't do anything.  I tried setting both to end at 6,000, but the middle increments did not change.

[fhill]

Can you either post your PBIX File, or provide us sample / mock data so we can duplicate your visuals how you built them?  FOrrest

[Roseventura · Accepted solution]

I think I just figured this out.  It has to do with the SIZE of the visual.  When I make the Customer visual longer,

it adds in the extra increments (see below).  Vice versa with the Mfg Part, it removes increments.

And it doesn't matter that the size (h x w) of the visuals are exactly the same.  It is governed by the size of the Y axis labels.

Because the Customer Name labels are longer and take up more room, that leaves less room for the bars.

Thanks for your help. 

Rose