Format Pane

This section consists of all the settings and formatting options that fall under the “Format” pane offered by the Powerviz. It includes settings like number formatting, 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

Visual settings 1. Powerviz license

2. Visual settings

3. Number formatting

4. Legend

General settings

5. Properties

6. Title

7. Additional settings Visual settings

Powerviz license

Once you've joined Powerviz, you'll have access to all the visuals in the library. You have received your credentials, which you must enter here to use the pro version.

Click here for more information about pricing and the free trial.

Visual settings

Visual settings show and hide the advanced settings icon. This icon gives you access to open formatting options and customize them. Read this article to learn more about advanced settings.

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

Number formatting

Use number formatting to format the measure value. This number formatting is very easy to use.

The number formatting provides the following option:

FeatureFunctionality

Decimal Separator

The decimal separator by default is full stop (1.23). It can be changed to any other symbol.

Thousand Separator

The thousand separator by default is , (1,000). It can changed to any other symbol.

Decimal Places

Choose the number of decimal places.

Scaling Display

Control the scale of value from the list of auto, none, thousands, million, billion, and trillion.

Prefix

The prefix comes before the value and can be customized.

Suffix

Suffixes come after the value and can be customized.

Customized Scaling Label

To modify the scaling format, use the “customized scaling label”. The word million for instance, can be spelled as millions, M, or Mn.

TIP

Disable the Number Formatting option to apply the default Power BI formatting. Recommended in case of % type value.

Legend

Legend helps in detecting the categories by associating them with a color.

These are the options under legend:

FeatureFunctionality

Position

It defines the placement of the legend on the visual. Pick from 12 unique options.

Legend Title

Input the name for the title.

Formatting

Customize the font color, size, and family.

General settings

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

Properties

The first option in the general tab is properties. The Properties option allows you to change the size and position of the visuals. You can choose the horizontal and vertical position 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.

FeatureFunctionality

Title Text

Enter the custom title.

Text Formatting

Font size, color, and family.

Advanced Formatting

Bold, italic and underline.

Background Color

Change the color.

Horizontal Alignment

Left, right and center.

Text Wrap

Wrap text into multiple lines.

In the recent update, you 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 tooltips, header icons, alt text, and effects that control the background, border, and shadow. You can turn them on or off to control the selected visual option.

Last updated