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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
myintuition
New Member

chart column width

I am have created my first dashboard with a simple chart.

I have a column for each month.

I place a chart on the power bi desktop and expand it to the width (11").

Then I turn on my first column.  The width is 2 1/4"

Then I turn on my second column and each column changes to 1 1/8" each totalling 2 1/4 for both columns.

This happens for each column I add (the width of the column reduces).

I end up with 12 columns in the same width which is 2 1/4"

 

How do I spread the columns over the width of the chart??

I look at other examples and cannot find anyone with this issue.

Seems crazy to me.

 

What am I doing wrong??

1 ACCEPTED SOLUTION

Ah, I see the issue now and was able to recreate what you are seeing. Basically this is happening because you do not have anything on the Axis. For example, if you had a column "Month" and another column "Value" then you would put Month in your Axis and Value in your Value and then you would not have this issue. You might try pivoting your data on import.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

7 REPLIES 7
Mariotouma
New Member

I have the same problem and nothing seems to be working 
I don't have "axis" and "values" fields; I have "x-axis" and "y-axis." I actually don't want anything on the x-axis for this visualization and it's really frustrating me.
Please help :'( 
1.jfif2.jfif3.jfif

Greg_Deckler
Super User
Super User

How are you expanding the column visualization to 11". I can only set this in terms of pixels. Generally, you place the chart visualization (I assuming column chart here, is this a different visualization?), add your Axis and Value and the drag the visualization to be the desired width and your columns will get wider or narrower. Are you on the January update of Power BI Desktop?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

yes just a standard clustered column chart and the chart is 11 inches.

This works perfect in excel using the same datasource.

But in power Bi, all the columns remain very narrow and only in the center of the chart (2 1/4" out of 11 ").

 

 

Sorry yes, I updated the latest version yesterday

Ah, I see the issue now and was able to recreate what you are seeing. Basically this is happening because you do not have anything on the Axis. For example, if you had a column "Month" and another column "Value" then you would put Month in your Axis and Value in your Value and then you would not have this issue. You might try pivoting your data on import.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks so much.

I brought in the data again and allowed power bi to do the work and this solved the issue.

Thanks!!!

What did you actually do, cause i have the same problem as you had...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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