topic Re: How to remove scientific notation from Measure in a Matrix in Report Server

How to remove scientific notation from Measure in a Matrix

Rudz — Thu, 30 Jan 2020 14:41:44 GMT

I have a Matrix with many measures. I have gone into Formatting > Field Formatting for every measure and set the formatting to Display units = Thousands and Value decimal places to 0. I have many data values in one column showing up in scientific notation. 2E-10, -4E-11, etc. How do I get these to show up as 0 K?

The data is coming from a direct connection to an SSAS data source. For SSAS data, you cannot change the formatting on the measure in PBI Desktop. Looking at the model in Visual Studio, the measure format is Whole Number, Show Thousand Separator = True.

I saw some posts suggesting using ROUND() to get rid of the digits. I literally have 1000 measures in this model and cannot make this change everywhere where I could need it.

Re: How to remove scientific notation from Measure in a Matrix

Rudz — Thu, 06 Feb 2020 16:50:50 GMT

Using ROUND(measure_calculation,0) is a workaround, but I keep running across more measures in my model that need this.

Scientific notation appearing when formatting as thousands, millions seems like a bug to me. How do I report this?

Re: How to remove scientific notation from Measure in a Matrix

Anonymous — Thu, 28 Jan 2021 22:57:56 GMT

Also keen for a solution to this.

Re: How to remove scientific notation from Measure in a Matrix

MarianoCatalano — Thu, 20 May 2021 17:51:04 GMT

I am having the same problem. No solution to this?

Re: How to remove scientific notation from Measure in a Matrix

MarianoCatalano — Thu, 20 May 2021 17:54:20 GMT

v-lili6-msft

Hi Lin, can you take a look to this? I am having the same problem. No answer from support team.

Re: How to remove scientific notation from Measure in a Matrix

MarianoCatalano — Wed, 26 May 2021 19:57:46 GMT

I reported this as a bug in

https://community.powerbi.com/t5/Issues/Matrix-displays-scientific-notation-when-Display-units-is-set-to/idc-p/1865562#M66947

Re: How to remove scientific notation from Measure in a Matrix

Kris2x5 — Fri, 15 Apr 2022 00:36:07 GMT

I responded to a similar question with a proposed solution here:
https://community.powerbi.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986