Power BI Axis, Data Labels And Page Level Formatting

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

 

To format the title of your chart, make the 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 the 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 the option to format X-Axis and Y-Axis. Format labels are shown on X-Axis with color, text size, font family etc.

 

 

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.

 

 

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 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.

 

 

 

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.

 

 

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.

 

 

Settings Page Background color or image >> as shown below you can choose the background color and transparency of it OR choose background image.

 

 

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.

 

 

That’s it for this article. Will see more of Power BI in other blogs/articles.