topic Re: How to remove Scientific Notation in DAX Commands and Tips

How to remove Scientific Notation

Anonymous — Thu, 13 Jan 2022 13:36:57 GMT

In my table data looks like Scientific Notation.please find the screen shot.

i have used below measure for the graph

Total Month =

IF(SELECTEDVALUE('Order Table Total'[Sno])="6.Total Month Variation",CALCULATE(SUM('Master Data Base'[Value]),ALLSELECTED('Order Table Total'[Sno])),

SUM('Master Data Base'[Value]))

how to trun off scientif notation in my report .

i am trying to Format i am getting Error.

Looking for support.

Re: How to remove Scientific Notation

amitchandak — Thu, 13 Jan 2022 16:02:55 GMT

Anonymous , check if the format you have check the Scientific , or force it to decmal

measure tools

Re: How to remove Scientific Notation

Anonymous — Mon, 17 Jan 2022 04:17:02 GMT

amitchandak sir have changed to Decimal but its still in Scientific .should i change to Excel also ?

Re: How to remove Scientific Notation

amitchandak — Mon, 17 Jan 2022 05:40:24 GMT

Anonymous , if this coming as Scientific from source, you can open and check power query, then better to change at the source. else you can try to change to decimal in power query too

Re: How to remove Scientific Notation

Anonymous — Mon, 17 Jan 2022 05:45:50 GMT

amitchandak thank you sir your support .let me check

Re: How to remove Scientific Notation

Anonymous — Thu, 20 Jan 2022 08:34:04 GMT

Hi Anonymous ,

If your problem still persist, you can refer the solution in the following blog to fix it by customizing the display format of the related column or measure to #.###########; 0; #.########### in the model view as shown below.

Getting rid of scientific format for decimal numbers in Power BI

And please change the data type to Decimal, and set decimal places to special number as below screenshot.

Remove Scientific notation in measure

Best Regards

Re: How to remove Scientific Notation

Fda — Wed, 10 May 2023 13:52:06 GMT

Anonymous any way you use this solution and can keep the thousand seperators?