100% Stacked Column Chart - remove decimal places

[ReubenPearse]

How do I remove the decimal places on this chart? The decimal place option is greyed out.

I also want to make sure that all y axis columns headings are displayed (these are months of the year).

I would also like the legend order to match the order displayed on stacked bars (at the moment they are swapped)

Thanks in advance

Reuben

[v-micsh-msft · Accepted solution]

Hi ReubenPearse,

We could just input 0 to remove decimal places in the data Label phase.

The decimal place is the place where to input the number of the decimal places that we would like to keep.

That place is not greyed out, it will keep 2 decimal places by default, with the grey Auto shown in the decimal places.

Regards

[CahabaData]

highlight the visual so it is outlined - and that will cause the table to highlight in the right Field Pane

in the Field Pane expand the correct table, and then select/highlight the field you wish to change - so that it is outlined

then up in the ribbon, Modeling tab, Formatting section - change the format....