Adding space in Clustered Column Chart

Hi mello ,

This is a clustered column chart so the values are automatically clustered if you don't select any values for your axis you only have one aggregation that is no aggregation so you get no spaces between the columns:

If you have an axis value or a legend the you get some spaces:

Again since you have several measures within each category within the same cluster (category / axis value) you don't have a space between the columns.

In you case I assume you are using measure for your chart in this case you need to make use of a disconnected table to show the values you need and use a switch measure to separate the values something similar to:

Measure for bars = SWITCH(
SELECTEDVALUE(MeasureSelection[MeasureSelection]),
"Values", SUM('Table'[Values]),
"Measure", [Measure])

This has to do with the way the chart works, in Excel you  have an extra option that is the series Overlap that is not present in Power BI so the bar appear by default with 0 spacing and can only be change by adding the axis values.

Believe this comes from the fact that in Power BI the X-axis values is created by default has a series and on Power bi you have to be explicit about it.