cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
silolondon Regular Visitor
Regular Visitor

Resize Bar Width?

Is it possible to make bars in a stacked chart wider than they appear by default?

 

I'd like a wide 100% stacked bar to represent my data, but would have to make a bar chart unfeasibly large to get the bar wide enough.  Currently I'm using a treemap for the visualisation, but they change shape and order depending on the data values.

 

bar1.jpgbar2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Resize Bar Width?

For single bar in chart, this can be a problem. I recommend you submit a feature request about adding a size property under Format tab for stacked chart visualization on: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

 

3 REPLIES 3
Moderator v-sihou-msft
Moderator

Re: Resize Bar Width?

@silolondon

 

In Power BI, the width of bars in stacked/100%stacked column chart is also based on data values. Since the shape of a bar is measured with other bars as well, we have to resize entire chart to resize those bars.

 

Regards,

Highlighted
silolondon Regular Visitor
Regular Visitor

Re: Resize Bar Width?

@v-sihou-msft

I understand that's how it currently works, but if you look at other chart products (such as Excel), you can resize the width of bars to be more visually pleasing.

 

See this screenshot as an example of how much space gets wasted:

, charttoosmall.png

 

The bar (the actual star of the show), takes up around 20% of the chart area.  It's not good.

Moderator v-sihou-msft
Moderator

Re: Resize Bar Width?

For single bar in chart, this can be a problem. I recommend you submit a feature request about adding a size property under Format tab for stacked chart visualization on: https://ideas.powerbi.com/forums/265200-power-bi-ideas