Format Chart Tooltip Data

So you are creating this report with a list and a chart. One of the data to display is a percentage value. When the mouse is over a market the percentage value is not formatted. Naturally you want the data in the chart to be formatted as that in the list.

proceed to set your series data format to percentage.

After running the report, nothing changed. The data in the chart is not formatted as a percentage value. You spend hours and hours revising the formula (because of course in the real world the report is not as simple as this example), and setting the format to no avail (just like I did).

Then suddenly, when all hope seem lost, your focus shifted to the default measure. Whatif I format the default measure, you say to yourself. Then you tried, because maybe, just maybe…

Viola!!!!! The chart data is formatted!!! All is well.