cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

 

 

View solution in original post

4 REPLIES 4
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,

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

 

 

View solution in original post

giftedbrain Regular Visitor
Regular Visitor

Re: Resize Bar Width?

@v-sihou-msft  How can I do this for all the bars in a Clustered Bar Chart?
 
 
 
 Thanks, Bhoga

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 144 members 1,457 guests
Please welcome our newest community members: