Data Labels And Axis Style Formatting In Power BI Report

In this blog, we will see how we can format legend, axis labels, and data labels in a Power BI Report.

In this blog, we will see how we can configure some of the important properties related to Power BI charts, like x-axis, y-axis, title, data labels, etc.
 
Let’s get started.
 
Note
The below configuration and steps are applicable to both Power BI desktop and Power BI web service online.
 
Open Power BI desktop application >> Create a new Report or open your existing .PBIX file. 
For Power BI web service – open the report in "Edit" mode.
 
Select or click on any chart for which you want to do the configurations >> click on the format icon on the right side to see the formatting options, as shown below.
 
Legend, Data colors, Detail labels, Title, Background, Tooltip, Border
 
Data Labels And Axis Style Formatting In Power BI Report
 
To format the title of your chart >> Do configuration from the Title section as below >> Set color, size, font-family, background color, alignment.
 
Data Labels And Axis Style Formatting In Power BI Report
 
To format the labels shown on the chart >> Configure formatting options from Detail labels menu as shown below [Note: Depending upon the type of chart these settings vary, check the next step for column chart]
 
Data Labels And Axis Style Formatting In Power BI Report
 
For a column chart >> you will see an option to format X-Axis and Y-Axis >> As shown below Format labels are shown on X-Axis with color, text size, font family, etc.
 
Data Labels And Axis Style Formatting In Power BI Report
 
Formatting Data Labels >> This is important in any chart; the values should be focused more in the chart >> By default these values are not visible >> To see values on the chart you need Set Data labels to On >> You can set color, size, background, etc. for data labels from this section.
 
Data Labels And Axis Style Formatting In Power BI Report
 
As shown below I am showing the data labels outside the columns with the background color. Choose "Show Background" as Yes and set the color.
 
Data Labels And Axis Style Formatting In Power BI Report
 
You can set the position of data labels at various places – Outside End, Inside End, Inside Center, Inside Base. You can choose the orientation to horizontal or vertical.
 
Data Labels And Axis Style Formatting In Power BI Report
 
How to set different colors to bars/columns depending on a data value in a chart?
 
From Data colors menu under formatting >> you can set a specific color to a specific value bar/column.
 
Data Labels And Axis Style Formatting In Power BI Report
 
That’s it in this blog. Hope this helps you in making your reports look attractive.