Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

MarianoCatalano

Matrix displays scientific notation when Display units is set to millions

Submitted by Advocate I on ‎05-26-2021 11:27 AM

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
See more ideas labeled with:
4 Comments (4 New)
Comments
MarianoCatalano
Advocate I
Advocate I
‎05-26-2021 11:41 AM

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

v-chuncz-msft
Community Support
Community Support
‎05-27-2021 01:55 AM

@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
Advocate I
‎05-27-2021 05:17 AM

@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
Advocate I
‎05-27-2021 05:38 AM

@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

 

Idea Statuses