Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

How to remove Scientific Notation

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.

Help appreciated

Anonymous
4 years ago
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

6 Replies

amitchandak
Super User
4 years ago
Anonymous , check if the format you have check the Scientific , or force it to decmal

measure tools
- Anonymous
  Not applicable
  4 years ago
  amitchandak sir have changed to Decimal but its still in Scientific .should i change to Excel also ?
  - amitchandak
    Super User
    4 years ago
    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