CODEWITHSUNDEEP
powerbi
Desert Spider
Desert Spider

Reputation: 778

Bar Chart spacing power BI visuals

Good afternoon community,

I am struggling with the latest PBI interface and the visual for a bar chart. The current settings and all that I have manipulated leave a great deal of white space and an unpleasing visual. Power BI screen shot enter image description here

I dont like all of the unneeded white space to the right and left of the chart, I also cannot figure out how to make the labels appear under the columns. Here is more what I would like it to look like from excel...

enter image description here

The below is much more visually appealing but the excel interface is 1990 - never. I need power BI to be closer to the view from excel.

I would attach the sample pbix but I cannot find instructions for that. If anyone wants the example pbix to help with this issue please instruct me how to attach the file.

Upvotes: 0

Views: 5759

Answers (1)

Marcus
Marcus

Reputation: 4015

You are using a clustered column chart, and you have used a categorization in the legend field instead of the x-axis field.

Here is the same chart using the same COUNT measure and the VAR categorization column. The left plot (which is what you apparently want) is what you get if you use either a clustered or stacked column chart, but without any categorization in the legend field. The right plot shows what you have now, where you have used the categorization in the legend field instead of x-axis field.

enter image description here

The left plot is configured like so:

enter image description here

Upvotes: 1

Related Questions