Select your language

pbi logo no text klein

     Power BI Consultants

 

 

kpi matrix color detail 300x300Formatting

 

Once at least an actual value has been assigned to the visual, the formatting pane will be visible.

There are three main formatting areas:

kpi_matrix_formatting_1_en.pngSettings - most of the visuals formatting options

Row settings - formatting related to specific row data elements

Column settings - formatting related to specific column data elements

Row settings and column settings allow the formatting of specific data rows or columns. They are not visible if there are no row or column fields assigned to the visual (cf. data)

Settings

kpi_matrix_formatting_2_en.pngGeneral - general formatting

Tiles - card related settings

Row header - row header formatting

Column header - column header formatting

Indicator - indicator settings

Minichart - minichart formatting

Conditional background - settings related to the conditional coloration of the card background

The "Row header", "Column header", "Indicator" and "Minichart" areas will not visible before an according data mapping has been made. E.g. you see the "Row header" category only if there is a field assigned to the row data mapping of the visual, and "Indicator" only if there is a field assigned to the target value data mapping (cf. data).

General

kpi_matrix_formatting_3_en.pngTile shape - choose between rectangular and square shape

Tile margin - space between the cards (pixels)

Tile padding - card padding, i.e. distance between content and edge (percent)

Tile minimum width and minimum height - minimum size of the cards. Cards are automatically sized to fill the whole area of the visual, but will not be smaller than the here defined minimum size (pixels)

Tile border width - stroke width of the card borders (pixels)

Tile rounded corners - rounded corners extent (pixels)

Automatic text size - automatically size the card texts (actual, target, row and column header texts) or not. Turning the automatic sizing on will display a slider where users can set the relative size of the texts in relation to the card size on a scale from 1 to 100

Tiles

kpi_matrix_formatting_4_en.pngTile color - background color of the cards

Tile border color - border color of the cards

Decimal places - default number decimal places for actual and target values

Display unit - defautl display unit for actual and target values

Actuals font - text settings for the actual measure

Target font - text settings for the target measure and its title

Row header

kpi_matrix_formatting_5_en.pngWhen using images as row header, the font formatting section is not visible. Otherwise the panel contains the following:

Tile color - color of row header tiles

Tile border color - border color of header tiles

Font - font settings for the header texts

Custom width - by default, header tiles will have the same size as the KPI cards. Turning "Custom width" on will let users define a custom row header width.

Column header

kpi_matrix_formatting_6_en.pngTile color - color of column header tiles

Tile border color - border color of header tiles

Font - font settings for the header texts

Custom height - by default, header tiles will have the same size as the KPI cards. Turning "Custom height" on will let users define a custom column header height.

Indicator

kpi_matrix_formatting_7_en.pngStyle - you can choose from three options: arrow, text color, no indicator

Targe style - display delta or target value under the actual value

Delta text - text to be displayed before the delta value (if target style = delta)

Target text - text to be displayed before the target value (if target style = target)

Positive color, neutral color, negative color - colors to be used for the indicator

Neutral percentage - percentage to be considered neutral

Reverse indicator - give values below target a positive indication and values above target a negative indication (e.g. when displaying costs)

Minichart

kpi_matrix_formatting_8_en.pngThere are two minichart types to choose from: Line and Indicator area. The area chart has no further options. For the line chart an actual and a target line color can be defined.

Minichart type - line chart or indicator area, i.e. area chart with IBCS like indication of actual vs. target

Actual line color - color of the actual line

Target line color - color of the target line

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.