Apply Static Formatting to Define Different Views

  • 20 February 2024
  • 0 replies

Userlevel 3
Badge +3

Static formatting in Pigment is used when you want to apply formatting or a certain style to your data in Lists, Metrics, and Tables in Grid or KPI display mode. Static formatting is applied to a specific View, allowing you to have multiple Views with different formatting. This can include specific cells, font style, value displaying, and colors. It's useful when you want to present your data in a more efficient and visually appealing way.


Apply Static Formatting

  • Click Format. Static formatting opens and the following selection shortcut is available: 
Selection Shortcuts 


Static Formatting Options


When you select a header, you will be given the three options on what should be formatted, the selected areas will pulse to highlight what will be formatted. 

  • Whole row / Whole Column. Selects the cells and headers, depending on which header is selected. 
  • Header. When selected only the header is formatted.
  • Cells. When selected, the cells of the row, column, or metric that was selected will be formatted.
  • Only my selection. This ensures the formatting is only applied to the selected header or cells. 
  • Every instance of my selection. Applies formatting to every instance that a Metric or item is repeated throughout the entire Metric or Table, even if selections are not visible when applied.
  • All rows/columns in the group. Applies formatting to all the items with in the group, including any new items that might be added to that group after you are done formatting.  

    When there are two Dimensions in a row/column a group would be considered all of the items in the lower Dimension that are associated with an item in the upper Dimension.

    For example, if you had Quarters and Months in Rows, if you selected this option on January in Q1, it would include, January, February, and March. 

  • All rows/columns. All items in the selected row or column.

Applying Static Formatting to a Specific Selection
  • Clear formatting. Resets all static formatting applied to the selection, even if previously applied using Every instance of my selection. 
  • Select all cells. Selects all cells, it will not include headers unless the headers option is selected.

Colors and style

  • Background and Text color. You can link two colors by clicking the Lock icon. If the lock icon is on, the text and the background are used together in future selections. Click the Lock icon to unlink the associated colors if you prefer a different customization. 
  • Font. Select B for bold and I for italic formatting. 
  • Text alignment. Align the position of your selected text to the left, right, or center. 

  • Cell borders. Applies a border to selected cell walls. The selection is applied to each individual cell that is highlighted. 

Color and Style Formatting


  • Decimal. Removes or adds a decimal to the selected cells 
  • Prefix. Text is added before the value 
  • Suffix. Text is added after the value
  • Multiplier. Displays values in :
    • %
    • basis point
    • thousands
    • millions
    • billions


Number display

  • Zero value. Select the value you want to show for zero.
    Options are 0, - , or (empty).
  • Positive Numbers. Select the value you want to show for positive values.
  • Negative value. Select the value you want to show for negative values.
    Options available are, - or ()
  • Reverse signs. Activate this option to multiply by -1 all the items of a Metric.
  • 1000 separator. Activate this option if you want to display a thousand separator.


Text display 

Select one of the following to determine how text is formatted: 

  • Text. Text is displayed without any formatting. 
  • Rich Text. Allows you to apply bold or italic formatting to text in your Metrics. 
  • Turn URLs into Images. For more information on formatting cells to use images, see Displaying images in Metrics and List properties

0 replies

Be the first to reply!