How to add % in Tooltip for Bar Chart?

#1

Is that possible to add % for tooltip in a bar chart when I point to one of the bar?

E.g.: This Year: RM8,377,939 (42%)

Image title
q1Io8RpGRaWwzruDCcKf_DD_1.PNG1073×503

#2

Definitely, however it is only built in for the stacked bar.


Is the % in the data anyway?

If it isn't then you will need to use a calculated measure - $This Year$ / SUM($This Year$ - to add it into the chart as another measure, and set it to hidden.


Once you the calculated measure in the chart, you can add it in to the tooltip with the parenthesis around it as ([calcMeasureName]) or you can set the formatting in the measure settings to include a parenthesis before and after.

#3

Hi David,


Thank you very much. It works well with added a calculated column.

#4

Glad to hear that.