MicroStrategy ONE

Changing the number format of the metric values (widgets)

This formatting is available for:

To format the number type of the metric values

  1. Open the document in the Document Editor. (How?)

    You can also use Design Mode or Editable Mode in MicroStrategy Web.

  2. Select the Grid/Graph containing the widget.

  3. In the Property List: Appearance section, set View mode to Grid.

    If the Property List is not displayed, click Property List at the bottom of the panel on the left. If the panel is not displayed at all, select Property List from the View menu.

  4. Edit the Grid/Graph by double-clicking it. A red hashed border displays around it, indicating that the Grid/Graph is in edit mode.

  5. From the Format menu, select Metrics or a specific metric, then choose Values. The Format Cells dialog box opens.

  6. Select the Number tab.

  7. Choose a Category. The Settings and Sample sections of the dialog box change depending upon the category selected.

  8. Use the Settings area to make your number formatting selections.

    • For example, if you select Date as your category, the Settings area allows you to choose which date format to use, such as 4/12/23, April 12, 2023, 4/7/2023, and so on. If you select Fixed as the category, you can determine the number of decimal places to be displayed, whether you want numbers to be separated every three decimal places, and whether negative numbers are allowed.

    • After you select a setting, the Sample area updates to provide you with an example of your selection.

  9. Click OK to apply the number formatting.

  10. To exit edit mode, press ESC.

Related Topics