Power BI Axis, Data Labels And Page Level Formatting

In this article, we will see how we can format data labels, chart axis, and report pages in Power BI.

Data Label and Axis Formatting

 
We will see how we can configure some of the important properties related to Power BI charts, including x-axis, y-axis, title, and data labels. 
 
Let’s get started.
 
Note
The below configurations 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 the 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. You have the following options:
 
Legend, Data colors, Detail labels, Title, Background, Tooltip, Border
 
Power BI Axis, Data Labels And Page Level Formatting

To format the title of your chart, make the configuration from the Title section as below. Set color, size, font-family, background color, alignment
 
Power BI Axis, Data Labels And Page Level Formatting
 
To format the labels shown on the chart, configure formatting options from the Detail labels menu as shown below [Note: Depending upon the type of chart, these settings vary, check the next step for column chart].
 
Power BI Axis, Data Labels And Page Level Formatting
 
For a column chart, you will see the option to format X-Axis and Y-Axis. Format labels are shown on X-Axis with color, text size, font family etc.
 
Power BI Axis, Data Labels And Page Level Formatting
 
Formatting Data Labels:  By default, these values are not visible. To see values on the chart, you need set data labels to On. You can set the color, size, background, etc. for data labels from this section.
 
Power BI Axis, Data Labels And Page Level Formatting
 
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.
 
Power BI Axis, Data Labels And Page Level Formatting

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.
 
Power BI Axis, Data Labels And Page Level Formatting
 
How do we set different colors to bars/columns depending on a data value in a chart?
 
From the Data colors menu, under formatting, you can set specific colors to a specific value bar/column.
 
 Power BI Axis, Data Labels And Page Level Formatting
 

Page Level Formatting

 
Now we will see how to do styling changes to a page in Power BI report. You can change the size of the page, set background colors and wallpaper color or image easily.
 
Let’s see how we can do this.
 
Note
The below steps are applicable to both Power BI desktop applications as well as Power BI services (online).
 
Open Power BI desktop application >> Create new Report or open your existing .PBIX file.
 
Make sure none of the charts are selected OR click somewhere outside the chart as shown below. Then, on the right side, you see the accordion menu to configure Page level styling.
 
Power BI Axis, Data Labels And Page Level Formatting
 
You will see four options to configure
  1. Page Information – This includes Page Title, tooltip and Q&A settings
  2. Page Size – This helps you to choose the size of the page
  3. Page Background – Set background color or image
  4. Wallpaper – Set background color or image to the entire page, including the area outside the page.
Let’s see what kind of Page sizes we can choose >> as shown below you can choose the page sizes like 16:9 (default), 4:3, Cortana, Letter, Tooltip (this is used if you want to show one chart as tooltip of another chart – will see more detail in another blog), or custom.
 
Power BI Axis, Data Labels And Page Level Formatting
 
Settings Page Background color or image >> as shown below you can choose the background color and transparency of it OR choose background image.
 
Power BI Axis, Data Labels And Page Level Formatting
 
Set Wallpaper background color or image >> as shown below you can choose the wallpaper color with transparency OR upload an image to be used as wallpaper.
 
Power BI Axis, Data Labels And Page Level Formatting
 
That’s it for this article. Will see more of Power BI in other blogs/articles.