Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Advocate I

@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
Advocate I

@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
Advocate I

@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