How to show both $1.2M and $4.2K in the same Pie Chart?

[GTS_ONE]

Hi all,

So I know that you can set the display preference in a pie chart (or set it to auto) to show masked numbers like $4.9K instead of $4,900.

However, I know there's nothing in the default setting to make it dynamic, so that the same pie chart can show a million dollar value as $1.2M AND simultaneously show a hundred thousand value as $1.44K.

AND I also know that unfortunately, pie charts don't respect number formatting like if you do Format(1000,"$#K")

Anyone have any other brilliant work around to be able to show both $M and $K in the same pie? 

Thanks

[MFelix · Accepted solution]

Hi @GTS_ONE,

Believe that you want to have the value displayed in thew chart a workaroudn can be to create a tooltip page and then make the tooltip on the donut chart to link to that tooltip:

Check the documentation on tooltip pages.

Regards,

MFelix