Forum Discussion

scabral's avatar
scabral
Helper IV
2 years ago

Modify spaces between columns in clustered column chart

I have the following clustered column chart with year on the x-axis and count on the y-axis:

 

Is there a way in the setting of the chart to tweak the spacing between the bars so that there are no white spaces in between and the bars are centered above the year?  I understand what the chart is trying to display with blanks showing that there are no values for that category, but it looks funny on the chart with extra space and one column pushed all the way to the right or left.

 

thanks

scott

Need Help

5 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello scabral ,

     

    Actually this is not a  free space that you're referring to in your image, it's the space for your third legend which is pressure vessels which is in the case zero in year 2020.

    • scabral's avatar
      scabral
      Helper IV
      2 years ago

      I understand that, but is there a way to collapse that space and bring the other bars closer together?  And for 2019 there is only Production Machine, but i would have liked the bar to be more centered with the year.  It may not be possible, but wasn't sure.

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        2 years ago

        scabral ,

         

        yes the same is happening for 2019, because the data for the other legends is zero its getting a space for them. you can't filter out the missing legends because they're displayed for other years. 

         

        there's in the december update some modifications for bar graphs, check if you could do something regarding this.https://www.youtube.com/watch?v=PycL2_T0DxM

         

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi scabral 

    There is one problem with the visual. Where it is 0, the data level is not showing.
    If you remove the space, it is misleading information. Please think, that if users click on Focus mode or show table mode and download data, it will not show the item.
    Best option is
    Please create a measure, which can show the blank as 0 and use the measure in visual
    = If(IsBlank(YourColumnName  or Measure),0,YourColumnName  or Measure)

    So, it is more readable and understandable for the report viewer

    If solved your requirement, please mark this answer as SOLUTION.
    If this comment helps you, appreciate your KUDOS

    Thanks 
    Pijush