Skip to main content

Power BI

Needs Votes

Resize bar width for a single bar

Vote (441) Share
Chandresh's profile image

Chandresh on 06 Jun 2017 11:45:56

Is it possible to make a single bar in a stacked chart wider than they appear by default?
It takes more space in a chart, to increase a bar, need to increase a size of whole chart then only it is visible.
Can we get a option to increase the width of a single bar stacked chart?

Comments (48)
Chandresh's profile image Profile Picture

e6cb3e8a b5db-45bf-87b1-f2df11b8e60b on 05 Jul 2020 23:30:17

RE: Resize bar width for a single bar

Again, more problems when trying to show reports on large hi-res displays. You can do better.

Chandresh's profile image Profile Picture

72b0d836 78f0-4323-98f7-dff6b34dd422 on 05 Jul 2020 23:29:36

RE: Resize bar width for a single bar

Under X-Axis options for minimum category width exists...solved my problem mostly i think.

Chandresh's profile image Profile Picture

b5588148 8109-47d1-a40d-45e5262644eb on 05 Jul 2020 23:17:42

RE: Resize bar width for a single bar

You can play trick around. Step by Step explained

1. Select the bar chart

2. Go to Format options, and click X-axis

3. Select TYPE as CATEGORICAL. Then appears 3 options namely, (Minimum category width, Max size and Inner Padding)

4. Update the INNER PADDING option with 40-45% or as is ur requirement.

5. DONE :)

6. (Optional) Revert X-axis TYPE back to CONTINUOUS, if that is the requirement of ur project. The Previous Bar size change done will remain intact.

Chandresh's profile image Profile Picture

b5588148 8109-47d1-a40d-45e5262644eb on 05 Jul 2020 23:14:51

RE: Resize bar width for a single bar

I require the bar size other way round, by decreaing its size, as my dat displayed is less. So it would be great if we can decrease the size of bars in the chart manually too.

Chandresh's profile image Profile Picture

c5d59443 9f09-4678-855e-aba6c10d90a6 on 05 Jul 2020 23:14:24

RE: Resize bar width for a single bar

please! this is necessary!

Chandresh's profile image Profile Picture

f9b4b92c 865e-4a80-8df9-af3838d7a754 on 05 Jul 2020 23:14:15

RE: Resize bar width for a single bar

Gets my vote - would be great to specify the width of the bars especially when there is only one.

Chandresh's profile image Profile Picture

7a9aab70 b627-45a8-bbab-4ee38657d479 on 05 Jul 2020 23:04:31

RE: Resize bar width for a single bar

when we use the clustered column chart, if we add values to it, they're all clustered in the middle of the x-axis. I have this extra space to the left and right of the columns I'd like to utilize, please help

Chandresh's profile image Profile Picture

97441c7d d8ef-4ddd-b80f-44696ccda06b on 05 Jul 2020 22:50:33

RE: Resize bar width for a single bar

I agree. Especially when we use filters in the report, some bar charts will only show 1 or maybe 2 bars which are really tiny unless the complete chart is made bigger (which obviously shouldn't be necessary. In my opinion the process to automatically determine the bar width should be: 1. Determine the size of the chart, 2. Determine the amount of bars to show, 3. Equally fill the space of the chart with the bars.
In addition, add the option to determine the width of the bars automatically or manually. When automatically is chosen, proces as described above. When manually is chosen, the user sets the width of the bars, risking the fact that when the chart is too small, these bars will not show in the chart. To fix this, add a scroll option to the chart when there's more data to show then there is space for it.

Would love to see this feature for all bar charts.