Use Metric Formatting

When we enable data labels in any of the vitara charts, by default, vitara charts will display data labels in short format.

If we want to display the data labels in same format as the metric’s data format, we have to select Use Metric Formatting option in the data lables menu. Below is the screenshot after enabling the Use Metric Formatting option.

If the metric’s data don’t have currency symbols, then how to display currency symbols in the data labels.

Lets consider the data as shown in the below screenshot. Here the metric Sales does not have dollar sign.

If we want to display this data using vitara charts and we want to show the dollar sign in the data labels, first we have to add dollar sign to the data. In the MicroStartegy, edit the number format of the metric and choose the format according the requirement.

Below is the screenshot of the data after selecting currency number format with dollar sign.

Now apply vitara chart, for example, vitara column chart.

When we enable data labels, by default vitara chart will display data labels in its own format i.e. short format. If we want to the values in the MicroStrategy format we have to enable the use metric formatting option.

Below is the screenshot of the vitara column chart after enabling the use metric formatting. Now we can see the dollar sign in the data labels.
datalabel_useMetricFormatting6 Note: When we enable the use metric formatting option in the data labels menu, the tooltip also will be displayed in the same format as the data labels.

Display axis labels in MicroStrategy number format.

To display axis labels in MicroStrategy number fomat, first enable use metric formatting option in the data labels menu, and then enable use metric formatting option in the axis labels menu. Below is the screenshot of enableing metric formatting in the axis labels menu.


Data label customization

In 4.2 release customization of data, labels has been introduced. We can modify the default data labels using text and dynamic macros for data. Below is the screenshot of the data labels editor window.


Hover the cursor over the ‘i’ symbol to see the available macros for any particular chart. Below is the screenshot.


In the editor window type ‘&’ character and you will see macro suggestions. Select the macros and click on ‘“Apply” tab.

For example, the default macros in the above screenshot is &[point.value], So the chart shows the metric value at each data-point. See the screenshot below:

Now we will use custom macros in this way &[point.metricName]: &[point.value], point.metricname is colored red. And the data labels will display this way now. See the screenshot below:

In this way, users can use either text or other macros or combination of both in many possible ways.

Show Overlapping Data Labels

From 4.1 version, all vitara charts are added with the support to show the overlapping data labels. This feature is added in data labels tab with ‘Show Overlapping Labels’ checkbox.

For example, in line chart when you enable data labels, only few labels are shown on the chart respective to the space available between the datapoints. See the screenshot below:

Now, the new feature allows to forcefully show all the data labels. To do this, go to data labels tab and enable the ‘Show Overlapping Labels’ checkbox. See the screenshot below:

Attribute forms in Data labels

For Data labels, now we can choose a particular attribute form to display on the chart. And we can select the attribute form macros only for the last attribute in the chart.
For example, if there are two attributes ‘category’ and ‘subcategory’, both enabled with attribute forms. Then, we can display the attribute forms for both attributes if needed.
To display the chart’s default attribute forms in the data labels, use &[point.category@DESC] or &[point.category@ID] or both macros based on the requirement. See the screenshot
To display attribute forms only for a specific attribute, then choose it from data label macros list. e.g, Category@DESC, Category@ID, Subcategory@DESC, Subcategory@ID.