Forum Discussion

myintuition's avatar
myintuition
New Member
10 years ago
Solved

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. ...
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    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.

myintuition's avatar
myintuition
New Member
10 years ago

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 ").

 

 

myintuition's avatar
myintuition
New Member
10 years ago

Sorry yes, I updated the latest version yesterday

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    10 years ago

    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.

    • myintuition's avatar
      myintuition
      New Member
      10 years ago

      Thanks so much.

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

      Thanks!!!

      • schmikli's avatar
        schmikli
        Icon for Helper II rankHelper II
        9 years ago

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