How to remove Scientific Notation

[Anonymous]

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.

[amitchandak]

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

measure tools

[Anonymous]

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

[amitchandak]

@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

[Anonymous]

@amitchandak  thank you sir your support .let me check 

[Anonymous · Accepted solution]

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

[Fda]

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