cancel
Showing results for 
Search instead for 
Did you mean: 

Matrix displays scientific notation when Display units is set to millions

The below matrix measures are formatted to display units in millions.

The problem shows up in matrix column and rows totals.

When the value is cero, it is displayed as you see it the following screenshot.

This happens in desktop and service.

 

MarianoCatalano_0-1622053159432.png

This problem was already reported by other users:
https://community.powerbi.com/t5/Report-Server/How-to-remove-scientific-notation-from-Measure-in-a-M...

but there is no answer from support on that issue.

 

 

Status: New
Comments
MarianoCatalano
Frequent Visitor

@v-lili6-msft can you help with this?

v-chuncz-msft
Community Support

@MarianoCatalano 

 

I tried the latest version and it seems to be working fine. You may try creating a measure that rounds the numbers between -0.0001 and 0.0001 to zero.

MarianoCatalano
Frequent Visitor

@v-chuncz-msft 

 

I mentioned previously that this happens also in the service. So I don't understand what you mean by latest version.

 

 

MarianoCatalano
Frequent Visitor

@v-chuncz-msft 

 

I just downloaded the last desktop version (Version: 2.93.641.0 64-bit (May 2021)). Same problem:

 

MarianoCatalano_0-1622119042757.png