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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
inglexjc
Helper V
Helper V

bar graph format

How do I get Bar Graph to have more space and line up with it's data source?

What I have: 

inglexjc_0-1742504407682.png

Spacing and line up I'm wanting:

inglexjc_1-1742504459324.png

 

11 REPLIES 11
Anonymous
Not applicable

Hi @inglexjc,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Vinay Pabbu

Anonymous
Not applicable

Hi @inglexjc,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Vinay Pabbu

Anonymous
Not applicable

Hi @inglexjc,

 

  • When using multiple measures in a bar chart, Power BI places all the bars on the same axis line. This means the bars are treated as different series within a single category, resulting in no vertical spacing between them and misalignment with category labels.
  • To achieve the desired layout—where each bar appears on its own row with proper spacing—we need to restructure the data by unpivoting the measures into a single column. This transforms each measure into a category, allowing Power BI to plot one bar per row, apply vertical spacing (via inner padding), and align bars correctly with their labels.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it !

 

Regards,

Vinay

Deku
Super User
Super User

Swap from clustered to stacked bar chart, and move the field in the legend to categories 


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

When I do that:

inglexjc_0-1742922133713.png

I get this:

inglexjc_1-1742922147099.png

 

 

create a table like this

yAxis = 
DATATABLE(
    "measure", STRING,
    {{"a"}, {"b"}, {"c"}}
)

 

and a measure

xAxis = 
SWITCH(
    SELECTEDVALUE( 'yAxis'[measure] )
    ,"a", [a],
    "b", [b],
    "c", [c]
)

and add to a stacked bar chart

Deku_1-1742922892253.png

 

 


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

Do I have to do a, b,c I want it to read Offline 3-4 weeks ect.  Also what am I doning wrong if I can have it list out the weeks?

Looks like table worked:

inglexjc_1-1743528809235.png

 

The xAxis measure is not working.

inglexjc_0-1743528780850.png

 

A, b, c was a example

 

Your error doesn't make sense in context of the measure that is shown.

 

The measure will only work if [offline ..] are measures, not columns.


Did I answer your question?
Please help by clicking the thumbs up button and mark my post as a solution!

They are measures, so what do I do?

I'm guessing there isn't a solution to this?

inglexjc_0-1743536190073.png

Does this help?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors