Product Feedback Forum
Help us make Sisense better by posting your product feedback here.
Showing results for 
Search instead for 
Did you mean: 
Status: Delivered

Is there any way to show all the values in millions even if data is in thousands, the default million formattings will show the values less that a million in the regular format







Hi @datanerd,
You can use custom currency format.
Just devide your value by 1 000 000 in the formula and add Symbol M.
Below is an example with thousands.


Best regards,



Hi @datanerd ,

You can also use below script (if you are using pivot2):

const myTarget = {
type: ['value'],
values: [
title:[ 'Value to Million'] // put here desired column

widget.transformPivot(myTarget, function(metadata, cell) {
	cell.content = (cell.value/1000000).toFixed(2) + 'M'




 Hi @datanerd@harikm007@Angelina_QBeeQ 

We have added a new option "Abbreviate all values" in the product. It has been included since L2023.11


 I would be glad to hear your feedback!




Great news! I have a quick update about your inquiry. Since this functionality is available in our L2023.11 release as mentioned by the awesome @Oleksandr_K, I am going to move this thread into the Product Feedback Forum and mark it as delivered. 



Status changed to: Delivered