Forum Discussion

Anonymous's avatar
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 Tabl...
  • Anonymous's avatar
    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