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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

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
v-vpabbu
Community Support
Community Support

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

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

v-vpabbu
Community Support
Community Support

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
Community Champion
Community Champion

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

 

 

Deku
Community Champion
Community Champion

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

 

Deku
Community Champion
Community Champion

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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