Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

set the proper padding in bar chart

I have a table that contains results from a survey. The question I want to visualize has 17 answers. One could check one or multiple answers. Hence, the table contains a column for each answer. The cells in each column contain either 0 or 1.

This is what the data looks like:

 

I want to visualize the answers in a bar chart (I guess it is called bar chart in English - I use the German version of PBI; there it is called "Balkendiagramm"). I have added the data columns like this (I only used the first 9 columns for the test in PBI):

 

 

I would like the bar chart to look like this (screenshot from Excel):

 

Instead it looks like this, with lots of white space above and below the bars:

I have already maxed out all the settings in the Y-Axis section:

The lables are German, but those familiar with PBI recognize these settings I'm sure. "Innenabstand" is "inner padding" I guess, but that setting doesn't put any padding in between the bars, it only sets the padding above and below ALL the bars, which seems more like the kind of padding in HTML/CSS.

So, how do I:

1. increase the padding between the single bars?

2. decrease the empty space above and below the bars?

 

 

There is a similar problem in this posting:

https://community.fabric.microsoft.com/t5/Desktop/Widening-bar-chart-width/m-p/1120678

The final solution was to report this issue. Is it really an issue that a bar chart cannot be maximized to its full height/width?

 

Thank you for consdering my question.

I am using Power BI Version: 2.105.1143.0 32-bit

No Replies