Forum Discussion
100% Stacked Column Chart - remove decimal places
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
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
2 Replies
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
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....
