Advocate IMatrix 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.
This problem was already reported by other users:
https://community.powerbi.com/t5/Report-Server/How-to-remove-scientific-notation-from-Measure-in-a-Matrix/td-p/916587
but there is no answer from support on that issue.
4 Comments
MarianoCatalanov-lili6-msft can you help with this?
v-chuncz-msftCommunity Support
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
I mentioned previously that this happens also in the service. So I don't understand what you mean by latest version.
- MarianoCatalano
I just downloaded the last desktop version (Version: 2.93.641.0 64-bit (May 2021)). Same problem: