Forum Discussion

SN1's avatar
SN1
Microsoft Employee
7 years ago
Solved

Thin columns in column chart when using time as axis

Update: Please vote for the idea to make this happen

---

 

My data has a single value for each hour in a 7 day timeframe. I want to display it as a column chart.

I did just that, and the columns are too thin and skinny. Is there a way to make them wider?

 

 

 

Column chart

 

 

I've tried using both stacked and clustered charts - but in both cases the spacing is the same.
If I switch the x axis from continous to categorical, the chart looks much better - but then not all of my values are displayed (I have 168 values).

 

Is there a way to make the columns wider?

4 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    SN1 ,

     

    I'm afraid currently stacked bar chart only can change the size of label and text in X-axis and Y-axis. I would suggest you to submit your idea here to help improve power bi.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    In a line and stacked column chart, under the formatting pane --> X-Axis, you can adjust the inner padding to be smaller. That should widen your columns.