Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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??
Solved! Go to 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.
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 :'(
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?
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.
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...
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |