Spacing in column chart

[kennyyip]

Hi,

I know it's been discussed in this post
http://community.powerbi.com/t5/Desktop/Spacing-between-bars/m-p/260273#M116264

However, can anyone illustrate with dummy data and an example of setting up a category column as mentioned in post above? Thanks a lot

Kenny

[quentin_vigne]

Hi @kennyyip

I personnaly use a trick to have spacing.

So what you need to do : 

1 - Create a new measure with this formula : 

Measure = 0

2 - Put it on the graph in the middle of the values needed 

3 - Blank the name by renaming it and writing a space in the name (simply press SPACE BAR)

4 - Choose a color in data color that match the background of your graph

Et voilà !

- Quentin

[roniedhaka]

hi, thanks for the wonderful solution. 

A couple of follow up questions- 

1)  you use a 'clustered column chart'? There is no traditional 'column' chart on the PBI desktop?

2)  The X-axis labels, how you put them?  For me, I can only see 'data labels' and place in/out of columns. But I need individual columns label text at the bottom. How to place that? Like the below screenshot-  i want each column bottom shows ASIA, AFRICA respectively, not like a group currently. 

[jbhovden]

@quentin_vigne does this still work for you? If I try to add multiple of the same measure, it will only show one in the chart. See pictures below:

[100goals]

Yeah it will; but you can make multiple measures = 0 to create more.  In the image, the '_' are different measures BarSpacer1 = 0 , BarSpacer2 = 0 etc., and there are two spacers next to each other on either side of the middle group of bars. 

Oh yeah also, change the "Show value as" to "Percent of grand total" to get rid of those ugly "0"'s on the bottom! 

I hope that helps others out too!

Mat 

[sr12]

Hello @100goals,

I cant rename the measures=0 as blank using the space bar. How can i show these measures as empty so they dont show in the chart?

[kennyyip]

Thanks. It works almost perfectly except I could type in blank as measure name...what character did you use?

[Markzolotoy]

@kennyyip Were you able to type blank characters in?

[rce2119]

use the space bar

[quentin_vigne · Accepted solution]

@kennyyip

The measure name you don't need to change it

You just need to rename it while adding it to the graph : 

If this worked, don't forget to mark the topic as solved 

- Quentin