Forum Discussion

kennyyip's avatar
kennyyip
Icon for Helper I rankHelper I
8 years ago
Solved

Spacing in column chart

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 sett...
Need Help
  • quentin_vigne's avatar
    quentin_vigne
    8 years ago

    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

quentin_vigne's avatar
quentin_vigne
Icon for Solution Sage rankSolution Sage
8 years ago

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's avatar
roniedhaka
Frequent Visitor
5 years ago

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.