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
To format the title of your chart >> Do configuration from the Title section as below >> Set color, size, font-family, background color, alignment.
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]
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.
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.
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.
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.
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.
That’s it in this blog. Hope this helps you in making your reports look attractive.