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.
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.
@v-lili6-msft can you help with this?
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.
I mentioned previously that this happens also in the service. So I don't understand what you mean by latest version.
I just downloaded the last desktop version (Version: 2.93.641.0 64-bit (May 2021)). Same problem:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.