General Formatting

There are multiple options in general formatting. For a  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.

The following are the steps:

Step 1: Click on the Title option. A drop-down list appears. Add the title, under the Text section. For example, Sum of Bonus and 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.

The following are the steps:

Step 1: 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 this chart, there are three options, filter on visuals, More Focus, 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, Sum of Bonus 50K, and Total 20K. 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 Line and Clustered Column chart is a combination of a line chart with a clustered(segregated) column chart. We could add a secondary y-axis, with just 2 mouse clicks in Power BI. We have various options to format line and clustered column charts, we can change the value of the x-axis, y-axis, its title, etc. We can also add various options like series labels, markers, and data labels in this chart. In this article, we will learn how to format a Line and Clustered Column chart in Power BI and explore its various options.

Formatting a Line and Clustered Column Chart In Power BI

After the successful, creation of a line and clustered column chart in Power BI, we have multiple options to format it. For example, adding the title to the chart, changing the color, and position of the chart, and adding tooltips, bar colors, data labels, and series labels to the chart. We have been given a dataset, name, and Employee, and we have created the Line and Clustered Column chart, by adding the Employee name in the x-axis, bonus(annual) and Joining Bonus in the y-axis, and salary in the secondary y-axis. Using this chart, we will explore every option of this chart in Power BI. There are two types of Formatting in visualizations i.e. visual formatting and general formatting.