Forum Discussion

kennyyip's avatar
kennyyip
Helper 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
Solution 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

jbhovden's avatar
jbhovden
Frequent Visitor
6 years ago

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:

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hello Anonymous,

       

      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?