Format Pane
Last updated
Last updated
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
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 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.
Use number formatting to format the measure value. This number formatting is very easy to use.
The number formatting provides the following option:
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:
General settings contain the Power BI native features that are common in all visuals. Read about them in detail here.
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.
Add a title to your visuals. The title card offers the following features.
In the recent update, you can also add subtitles and a divider. They come with font style and color formatting options.
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.
Feature | Functionality |
---|---|
Feature | Functionality |
---|---|
Feature | Functionality |
---|---|
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.
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.
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.