Data Labels in Models

[former_member787673]

When creating models (specially bar charts) from the dataset, I can't find any option to change the data labelling from a figure to a percentage.

In data exploration mode, I am able to change this (Image 1 - wrong-labels-2.png)

But when translated into story view, these labels revert back to a number (Image 2 -

Any guidance would be greatly appreciated.

[dhirendra · Accepted solution]

You can create a calculated measure using %GrandTotal function to get the % values

See attached screenshots for the calculation and charts

Hope this helps

-Dhirendrasalepct.pngsaleschart.pngsalespctchart.png

[Daniel_Davis]

Use the %GrandTotal() function to give you a % part of the total of a measure. For example:

%GrandTotal(["Model_Name":Measure_Name] )

This will give you the % for each dimention that you show your chart by.