General Formatting in Format Column Chart

There are multiple options in general formatting. For a column chart, we have options like Title, tooltip, effects, alt text, etc. We will look at each of the options in detail.

Property

The property option is generally present in every visualization. It contains three options, Size, position, and Advance options. We, generally do not use these properties, because all are easily accessible with mouse clicks. The size property helps to resize the visualization created. The position property changes the position of the visualization, in the report. The Advance option comprises adding a layer order, which is rarely used.

Title

The title formatting is present in every visualization. As the name suggests, it adds a heading to the visualization. Click on the slider to enable the title. Let’s understand by following steps:

Step 1: Click on the Title option. A drop-down list appears. Add the title, under the Text section. For example, Sum of Salary by Employee Name and Department. We can view in the image a title is added to the chart. As done previously we can customize the size, font type of the chart, etc.

Step 2: We can also change the color of the title. Under the text color, select the required color. For example, yellow in this case. The title color changes to yellow.

Effects

The effects section comprises three features i.e. Background, Visual Border, and Shadow. All works according to their names. The background adds a background color to the visualization, the Visual border adds a border around the visualization, and the shadow option creates a shadow on the outskirts of the visualization.

Click on the Background option. Select the color of the background accordingly. For example, Pink. We can view in the below image that the background of the chart changed to pink.

Header Icons

Header icons are the options, present on the top of the visualization. For a column chart, there are two options, filter on visuals and more options. Click on the header-icons option, we will get various options, like Background, Border, and Icons. One can set its colors as per choice.

Tooltips

If we hover over a visualization, then we cannot view any information related to the chart. Consider a situation, where we want to display the fields added by hovering over the chart, then this task can be achieved by the Tooltips option. Tooltips have three properties i.e. Options, Text, and Background. Click on the tooltips option. Now, for example, we hover over the bar, then we can view that the employee Name Arushi, Department IT, Salary 50K, and Total 50K is displayed. We can set text and background color according to our needs.

Alt Text

Alt text is a property present in each visualization. People generally misinterpret, alt text by its name, they think that alt text will be displayed when they hover over the visualization. Alt text is for the persons, who cannot see the visuals, images, etc. This option is only available if you are using a narrator in your system. When your narrator is active, then this alt text will be spoken by the system. Click on the Alt text, and type the required text. 

A column chart is a vertical chart, which could present a single bar with multiple stacks in it. We have various options to format column charts, we can change the value of the x-axis, y-axis, its title, etc. In this article, we will learn how to format a column chart in Power BI and explore its various options.

Formatting a Column Chart In Power BI

After the successful, creation of a column chart in Power BI. There are several ways we may format it. Adding a title, modifying the chart’s color and position, and adding tooltips, bar colors, and data labels are a few examples. We were provided a dataset, a name, and an employee. To make the column chart, we added the employee’s name to the x-axis and added the employee’s pay and bonus to the y-axis. We will examine every Power BI column chart option using this chart. In visualizations, there are two forms of formatting:

• Format X-xis
• Format Y-axis
• Visual formatting and
• General formatting, we will discuss all in this article.