Format Y-Axis of a Power BI Column Chart
Step 1: Click on the Y-axis option a drop-down appears. We have multiple options available here i.e. Range, Values, and Titles. Click on the range option, and a drop-down appears. Minimum and Maximum values can be set by the range option. By default, the minimum value is 0 and the maximum value is the maximum value of the dataset. We can also make the same chart, in a log scale, and can also invert the range of the y-axis.
Step 2: Click on the Values option, and a drop-down appears. The values are 0K, 20K, 60K, etc. A font is an option used to select the type of text we want to show on the y-axis in the chart, we can also set the size of the text, etc. The units can also be customized, to million, thousand, etc.
Step 3: Similarly, click on the Title option. For example, the title is Sum of Salary and Sum of Bonus. To change the color of the title of the y-axis, click on the color option. Select the required color. Here, we have selected orange color, and the Sum of Salary and Sum of Bonus is changed to orange color.
Power BI – How to Format Column Chart?
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.