Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Sebastian
Advocate II
Advocate II

only thin bars in bar chart with legend

Hi all,

 

i need help with my bar chart. 

I have created a bar chart which shows the value for my items.

If I only use the axis the visual shows the bars in the right size. If I also use a legend the visual only shows thin bars.

Is there a way to increase the size of the bars?

 

Bar Chart II.PNGBar Chart.PNG

 

 

Thanks for your help.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Sebastian,

 

The question related with this is that you have several categories for each x-axis value so he is making the spaces between the x-axis with size to acommodate all the categories, what I can see from your visual you have one categorie per x-axis value I would change my chart to a stacked column chart.

 

dd.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

6 REPLIES 6
Ashwin
New Member

Hi,

Please Ensure the "Type" is set to "Categorical". This will prevent Power BI from trying to evenly distribute space across a continuous range. from the "Format" pane, expand the "X-Axis" settings

MFelix
Super User
Super User

Hi @Sebastian,

 

The question related with this is that you have several categories for each x-axis value so he is making the spaces between the x-axis with size to acommodate all the categories, what I can see from your visual you have one categorie per x-axis value I would change my chart to a stacked column chart.

 

dd.png

 

Regards,

MFelix


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



The problem with using a Stacked Column Chart though is that you lose the option to have Data Labels positioned "Outside End". With a Stacked column chart, the value labels can ONLY be "Inside" the bars.

 

Is there a way to have both fat bars AND Outside End positions data labels?

Hi @feelie75 ,

 

Have you tried turnin on the Total Labels?

MFelix_0-1695369555942.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Oh hey MFelix, that's a great solution to the missing Outside End Data Labels issue, thanks for pointing that out.

Hi @MFelix,

 

Your absolutly right, it was a stupid mistake by myself.

Thanks for your answer.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.