I'm building a clustered column chart (photo below), and would like to resize the width of the bars in that chart if possible, but I am not having any luck finding a way to do this. I know that other version of this has been asked and answered already (http://community.powerbi.com/t5/Desktop/chart-column-width/m-p/17749#M5116), but the answer to those questions was "you are missing a field for your Axis", meanwhile I already have an axis value.
Any help? Thanks!
Solved! Go to Solution.
@TarcMaylor,
There is no method that could be used to change width of column unless we resize the whole chart to make the column wider. There is also an idea about adjusting blank space, you can vote it up.
Regards,
Step - 1
Select Clustered Column Chart from Visualizations, drag your data columns into visual
Step - 2
Click on your visual, goto Format and enable X-axis,
Step - 3
In X axis settings you can see Minimum Category width and inner padding tweak them as your wish
Problem solved 😊
You have to make sure under X axis that the Type is "Categorical" and not "Continuous" otherwise it won't let you adjust the category width.
Go to Format option and type Padding. In X-axis, you will find inner padding %. Now, change the % and you can see the width of the column altered. Changing the width of a column
Also under X-axis adjusting "Minimum Category Width" helps better than reducing the padding I found.
Has anyone found a better solution or workaround to this? Adjusting the inner padding or column width made very little change for me. Another chart type that can support field based target with conditional coloring on the bars (below or above target) would be fine.
Trying to get this right as well. I find the parameters of X axis are not doing anything. All I get is this silly looking chart:
@TarcMaylor,
You are able to change width of the whole chart as shown in screenshot below. However, it is not possible to resize bar width of a single bar, an idea about this issue has been submitted in this link, please vote it up.
Regards,
Lydia
@TarcMaylor,
There is no method that could be used to change width of column unless we resize the whole chart to make the column wider. There is also an idea about adjusting blank space, you can vote it up.
Regards,
I am finding that all of the suggestions, do not work for the most part. In Excel, one can easily make each column wider and reduce the amount of white space on the graph. Though dynamic, the visuals are very limited and very frustrating when trying to make visually appealing. Changes and formatting should not be this complicated. I wish I could increase the width of my columns to the size of the visual at the top of this page.
What everyone that is asking for this wants to do is to control the use of white space around a chart _and_ the width of the bars. This is a very reasonable thing to ask because without it the charts are not balanced in the amount of space they use -- for example, a chart with only 5 bars, if displayed in a larger width area, will be centered and have an unusual amount of white space around it, yes the bars will be bigger, but I want them over to the left, not centered, and I want them much wider than they will be if I shrink the width of the whole chart.
"No Method to change the width of the bar chart" This is NOT a solution.
I too am in the same situation - would like to increase the width of the bar charts since there is so much white space.
Jose
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.