Show all clustered bar chart X axis scale items

[Anonymous]

Hi,

I use basic clustered bar chart visual in my Power BI report and I have a problem with X axis items.

I want to see all X-axis items between start and end values (0 - 1 - 2 - 3 - 4 - 5 - 6).

Is there any way to display all items without resizing the visualization, because it is not possible in this case.

I have set scale start value 0 and end value 6 and now Power BI show automatically X-axis scale like below (0 - 2  - 4 - 6).

Example if I change scale start value 0 -> 1 visual show all value between 1-6.

Visualization size is same.

I hope you can advice some solutions for this 🙂

[v-lili6-msft]

hi  @Anonymous 

This is depends on the size of the visual, you could not set it manually.

Regrads,

Lin

[Anonymous]

Hi,

Is that really the only way to resize the visualization?

I have to almost double the width before it show all items 0 -> 6.

BR,

Heidi

[v-lili6-msft]

hi @Anonymous 

To my knowledge, this automatic adaptive size of bar visual, so it couldn't set it manually.

Regards,

Lin

[amitchandak]

@Anonymous , Change Axis type to Categorical

[Anonymous]

Which Power BI version you are using?

Because I don't see that setting.

[rogletree]

@Anonymous ah I think since the visual you are using is sideways, the x-axis is actually the y-axis and vice versa. Check the options for Y-axis and you should be able to change the type to categorical.

[Anonymous]

I use clustered bar chart visualization and in Y-axis settings can't found that kind of settings 😞

[rogletree]

@Anonymous that's really weird. Try doing a clustered column chart and see if the option shows up for X-axis.

Btw are you using Power BI Desktop? That's what I'm using.

[Anonymous]

Yes, I using Power BI Desktop and if I change the visualization to clustered column chart I don't have same settings as you have.

[rogletree]

What is the data type for the field?

[Anonymous]

Axis field format is text and values fields format is decimal number.

[rogletree]

Click on your visual, then on the visualizations pane click the dropdown arrow for the X-axis and change the type to "categorical". It should show all the values.