Power BI – Format Stacked Bar Chart

Formatting is a technique to enhance the looks of the charts by giving a cosmetic appearance to the chart title and chart legend. Titles are given to the X and Y axis to add clarity for the user. Formatting commands are applied to a chart for the identical reason they’re applied to a worksheet. they create the chart easier to read. However, formatting techniques also facilitate chart quality and explain the data in a chart. 

Stacked Bar Chart

A Stacked Bar Chart is drawn using the sample excel sheet below. Below is the dataset mentioned and the link to the dataset is here.

SampleDataSheet

The stacked bar chart of the dataset is mentioned below:

Steps to Format Stacked Bar Chart

Below are the steps that can be used to apply different formatting on the stacked bar chart formed:

• Click on the format icon under Visualization to format the chart.

• To Format the y-axis ‘Value’ click on the drop-down of the Y-axis.

1. Fonts are changed to ‘Cambria’
2. Font size is set to ’12’
3. Fonts set to ‘Bold’
4. Color set to ‘Black’
5. Switch axis position ‘ON’

• To Format the y-axis ‘Title’ click on the drop-down of the y-axis.

1. Title set to ‘Countries’
2. Fonts are changed to ‘Verdana’
3. Font sizes are set to ’15’
4. Fonts set to ‘Bold’
5. Color set to ‘Black’

• To format x-axis ‘values’ click on the drop-down of the X-axis.

1. Fonts are changed to ‘Cambria’
2. Font size is set to ’12’
3. Fonts set to ‘Bold’
4. Color set to ‘Black’
5. Value Decimal Place to ‘1’

• To Format the x-axis ‘Title’ click on the drop-down of the X-axis.

1. Title set to ‘Product Count’
2. Fonts are changed to ‘Verdana’
3. Font sizes are set to ’15’
4. Fonts set to ‘Bold’
5. Color set to ‘Black’

• To change the Legend of the Bar chart.

1. The position changed to ‘Center left’
2. Fonts changed to ‘Segoe UI Bold’
3. Fonts size to ’13’
4. Color to ‘Black’

• To add gridlines on the Chart, click on the dropdown Gridlines under Visuals.

1. Style Changed to ‘Solid’
2. The Color Changed to ‘Black’ 
3. Width Changed to ‘2’

• To get Slider on Values ‘ON’ Zoom Slider.

1. Slider on x-axis ‘on’
2. Slider labels are ‘on’
3. Green Arrow shows the Position for sliding the Bars

• To change the bar Color or stack click on the bar under the visualization.

1. The reverse Stack is ‘ON’
2. No colors are changed

• To change the Space between the bar click on Spacing

1. Inner Padding Changed to ’36px’
2. Minimum width to ’20px’

• To Show Values of each type on bars click on Data Labels.

1. Series are applied to ‘All’.
2. The position is set to ‘Inside Center’.

• To change the font and color of the data label click under ‘Values’.

1. Fonts changed to ‘Segoe UI’
2. Font size changed to ’11’
3. Font Style ‘Bold’
4. The color changed to ‘Grey’
5. Decimal Place to ‘1’
6. Background Transparency ’76’

• To show totals of Each bar ‘on’ Total Labels.

1. Font Changed to ‘Seogoe UI Bold’
2. Font Size to ’11’
3. Font Style ‘Italic’
4. Color to ‘Black’
5. Value decimal Places ‘1’

• To Format Table Position, Table Table Title, and Table Effect Click on ‘General’ under visualization.

• To manage the Size and Position of the table Click on the drop-down of Properties.

1. Height set to ‘680’
2. Width set to ‘981’
3. Horizontal position to ‘299’
4. Vertical Position to ’34’

• To change the Title of the Table click on the drop-down of the Title.

1. Title Changed to ‘Product vs Country’
2. Heading to ‘Heading2’
3. Font to ‘Constantia’
4. Font Size to ’22’
5. Font Style to ‘Bold’
6. Text Color to ‘Light Blue
7. Text Background to ‘Black’
8. Text Alignment to ‘Center’

• To give Color Effect To chart click on effects under General.

1. Background color changed
2. Transparency changed to ‘28%’
3. Visual border of color ‘Blue’
4. Rounded corners ’30px’
5. Shadows Color changed to ‘Black’
6. Offset changed to ‘Inside’
7. Position Changed to ‘Left’

• To change the color of the Icon on the Top click on Header Icon.

1. Background Color to ‘Yellow’
2. Border to ‘Black’
3. Icon to ‘Black’
4. Transparency to ‘0%’

These are a number of the most frequent formatting done on Stacked Column Charts. Power BI provides us with dynamic options to format a chart and it is often explored with some self-research easily.