Format Pane

This section consists of all the settings and formatting options that fall under the “Format” pane offered by Powerviz. It includes settings like title, background, and others. If you want to know about advanced settings, read this article.

Table of Content

The format pane is divided into 2 sections – Visual and General

1. Visual settings

   • Visual Settings

   • Number Formatting

2. General settings

   • Properties

   • Title

   • Additional settings

Visual Settings​

Visual Settings

Visual settings show and hide the "Advanced Settings" icon (⚙️). This icon gives user access to open formatting options and lets user customize them. Read this article to learn more about advanced settings.

[Below are the two images showing the on-and-off situation.]

Number Formatting

• Decimal Separator: Specify the character used to separate the integer part from the decimal part (e.g., period . or comma ,).

• Thousands Separator: Choose the character used to group thousands (e.g., comma , or space).

• Decimal Places: Define the number of digits to display after the decimal point.

• Scaling Display: Adjust the scale of numeric values for easier readability (e.g., converting large numbers to a compact format like "K" for thousands).

• Prefix: Add a text or symbol before the numeric value (e.g., currency symbols like $ or €).

• Suffix: Append a text or symbol after the numeric value (e.g., units like kg or %).

Customizable Scaling

• Thousands (K): Convert values to a scale representing thousands (e.g., 1,000 as 1K).

• Millions (M): Convert values to a scale representing millions (e.g., 1,000,000 as 1M).

• Billions (B): Convert values to a scale representing billions (e.g., 1,000,000,000 as 1B).

• Trillions (T): Convert values to a scale representing trillions (e.g., 1,000,000,000,000 as 1T).

These options allow users to adjust numeric values to different scales for enhanced readability and presentation.

General Settings​

General settings contain the Power BI native features that are common to all visuals. Read about them in detail article.

Properties​

The first option in the general tab is properties. The Properties option allows user to change the size and position of the visuals. User can choose the horizontal and vertical positions on the canvas as well as the visual size's height and width. With that, control the gap and layer responsiveness using padding and advanced options.

Title​

Add a title to your visuals. The title card offers the following features:

In the recent update, user can also add subtitles and a divider. They come with font style and color formatting options.

Additional Settings​

Moreover, the general settings include settings for Data format, header icons, Tooltips, Alt text, and effects that control the background, border, and shadow. User can turn them on or off to control the selected visual option.

Note - Data format settings apply exclusively to numeric data. Users can format these numeric values according to their preferences.