Select your language

pbi logo no text klein

     Power BI Consultants

 

 

kpi matrix color detail 300x300Formatting

Once at least a measure has been assigned to the visual, the formatting pane with the visual specific formatting options will be visible.

There are three main formatting panes:

symbol_chart_formatting_main.pngSettings - the visuals general formatting options

Multiple individual - formatting related to specific multiple data elements

Legend individual - formatting related to specific color legend data elements

"Multiple individual" and "Legend individual" settings allow to define formatting for specific data elements. They are not visible if there are no multiples or legend fields assigned to the visual (cf. Data)

Settings

symbol_chart_formatting_settings.pngChart - chart formatting (symbols to be used, symbol distribution)

Chart area - chart area formatting (size, borders, background color)

Value label - value label formatting (text style, size, color)

Multiple - multiple formatting (direction, spacing)

Multiple label - multiple label formatting (text style, color, image size)

Legend - legend formatting (position, size)

Layout - settings regarding the positioning of elements on the chart area (chart, multiple and value labels)

Chart

symbol_chart_formatting_chart.pngPosition - layout position of the chart on the chart area (cf. Layout)

Symbol - Selecton of a symbol to be used in chart. Selection of "custom" will show a text input where users can enter (or paste) their own SVG path expression to be used.

Symbol color - default symbol color, if no color legend is defined.

Symbol value type - definition of the numeric value one symbol in the chart should stands for. User can choose from "auto", "symbol" and "total". "Auto" will automatically assign a value based on the number of symbols and the measure value, or the maximum measure value across all multiples (if multiples are being used). "Symbol" will let users enter a specific value one symbol should represent. "Total" will let users enter a total value to be used when determining the value of each symbol (across multiples if multiples are active), by dividing the entered amount by the count of symbols.

Columns - number of symbols to be put in a a row

Rows - number of symbols to be put in a column

Horizontal spacing - space in pixels to put between the symbols in a row

Vertical spacing - space in pixels to put between the symbols in a column

Show empty symbols - turn on to show all symbols (all columns x rows) for each multiple chart, even if, by value, they should not be visible for that multiple. Can be used to show the max of all or a certain amount as a reference.

Chart area

symbol_chart_fomratting_chart_area.pngMinimum width - minimum width of the chart, or each of the charts multiples. When reached, a horizontal scrollbar will appear.

Minimum height - minimum height of the chart, or each of the charts multiples. When reached, a vertical scrollbar will appear.

Padding - padding to be applied on the chart areas content

Border width - with of the border around the chart area

Rounded corners - corner rounding to be applied on the chart areas border

Background color - background color of the chart area

Value label

symbol_chart_formatting_value_label.pngPosition - layout position of the value label on the chart area (cf. Layout)

Decimal places - the chart values default number of decimal places

Display unit - the chart values default number of decimal places

Horizontal alignment - horizontal alignment of the value label in its layout position

Vertical alignment - vertical alignment of the value label in its layout position

Font - font settings of the value label

Text color - text color of the value label

Multiple

symbol_chart_formatting_multiple.pngMultiple direction - direction (horizontal or vertical) to be used to place multiple charts

Spacing - space to put between multiple charts

Multiple label

symbol_chart_formatting_multiple_label.pngPosition - layout position of the multiple label on each chart area (cf. Layout)

Horizontal alignment - horizontal alignment of the multiple label in its layout position

Vertical alignment - vertical alignment of the multiple label in its layout position

Font - font settings of the value label

Text color - text color of the value label

Image size - size of the image (% of size of layout position), when using images as multiples

Legend

symbol_chart_formatting_legend.pngPosition - position of the legend (top or bottom of the visual)

Size - size of the legend in pixels. Text and symbols will be scaled proportionally.

 

Layout

symbol_chart_formatting_layout.png

Show layout areas - show or hide layout lines (to see if the layout is set correctly)

There are 15 layout positions to choose from when positioning element (chart, value label, multiple label) on the chart area: top row, top left, top center, top right, center row, left, center, right, bottom row, bottom left, bottom center, bottom right, left column, center column, right column. These positions are defined by setting the following formatting properties:

Top height - position of the top layout line (in percent of chart area height) that determines the height of the top layout row 

Left width - width of the left layout line (in percent of chart area width) that determines the width of the left layout row 

Right width - width of the right layout line (in percent of chart area width) that determines the width of the right layout row

Bottom height -  of the bottom layout line (in percent of chart area height) that determines the height of the bottom layout row

The size of the center space (and also the size of the center row and column) is the remaining space of the total chart area size (e.g. center row height =  total height - top height - bottom height)

We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.