Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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'.
Proud to give back to the community!
Thank You!
Unfortunately, that didn't do anything. I tried setting both to end at 6,000, but the middle increments did not change.
Can you either post your PBIX File, or provide us sample / mock data so we can duplicate your visuals how you built them? FOrrest
Proud to give back to the community!
Thank You!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |