how to transform the "e" into real values?

[oakfootballclub]

Hi experts, I'm wondering how to get the real mumbers rather than the characters, for example:

how to make the E in to values?

the datatype of the calculation:

[Anonymous]

Hi @oakfootballclub ,

Thanks for reaching out to our community.

I've tried to reproduce your scenario but failed.

Did you use the custom format?

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Please provide us with more detailed information about the issue.

If the issue has been resolved within these days. It's good to share your workaround with us.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[123abc]

To transform the scientific notation (e.g., -2.20E-5) into real numbers in Power BI, you can follow these steps:

Option 1: Format the column in Power BI

1. Go to the Data View in Power BI.
2. Locate the column containing the values in scientific notation.
3. Click on the column header, and in the ribbon, navigate to the Column Tools tab.
4. Change the column's data type to Decimal Number if it's not already set.
5. Adjust the formatting of the column to display the full numeric values:
   • In the Formatting section, choose Number and increase the decimal places to show the entire value.

     Option 2: Use a DAX Calculated Column

     If formatting does not work, you can create a new column to explicitly convert the values. Use the following DAX formula:

     RealValue = FORMAT('TableName'[ColumnName], "0.###############")

     This will convert scientific notation to a string with its full numeric representation.

     Option 3: Transform in Power Query

     1. In the Power Query Editor, select the column with scientific notation.
     2. Go to the Transform tab and select Data Type > Decimal Number.
     3. Power Query will convert the values into standard decimal format.

        Let me know if you need further assistance!

     I hope this helps!
     If you found this answer helpful:

     Mark it as the solution to help others find it faster.
     Give it a kudo to show your appreciation!
     Thank you for being an awesome community member!

[oakfootballclub]

If I want to transform all the value in the format of 12,345,678.12, and there is no scientific notation, how can I set them, noticce that this is a measure
Thank you

[123abc]

If the data is a measure in Power BI, you can control its format to always display values in the format 12,345,678.12 (comma-separated with two decimal places). Here's how:

---

Steps to Format a Measure:

1. Select the Measure:

   • In Power BI's Fields pane, locate the measure you want to format.

2. Open the Measure Properties:

   • Click on the measure to highlight it.

3. Set Formatting:

   • In the Measure Tools ribbon at the top, find the Formatting section.
   • Select Decimal Number as the format.
   • In the same section, set the number of decimal places to 2.

4. Enable Thousands Separator:

   • Ensure the option for using the Thousands Separator is enabled (this happens by default when you select the Decimal Number format).

---

Using DAX to Format in the Measure

If you want to explicitly format the value within the measure itself, use the following DAX formula:

FormattedMeasure = FORMAT([YourMeasure], "###,###,##0.00")

Notes:

• The FORMAT function converts the value into text, so it can no longer be used in numerical calculations. Use it only for display purposes.
• If you want to retain the numeric nature of the measure while formatting, follow the first approach.

Let me know if you need further clarification!

I hope this helps!
If you found this answer helpful:

Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!