Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Regular Visitor

Scientific notation when changing decimals in field formatting

We have data coming from a SSAS Semantic Model. The data is formatted as decimal with 2 decimal places. When adding data in a report it looks default like this: 



When using the default Field Formatting (auto) the numbers look fine and have 2 decimals, just like it is coming from the datamodel. In some cases we want no decimals, so i change the field formatting to use 0 decimals. When i do that it looks like this:


How can i avoid this? Using the round function is a workaround, but is not a usable solution in our case. With lots of measures and the need to sometimes use 2 decimals or 0 decimals, we then have to create each measure 2 times.



Community Support
Community Support

Hi  @Energy2k8 ,

You can change it to Whole number format.



Best Regards,

Liu Yang

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


Not totally clear on your scenario (havent seen that behavior), but you can likely use Calculation Groups to solve it.  It could be used with any measures you create and you could quickly choose which format you want to display.  For the expression, you can just use SELECTEDMEASURE() and then for the Format String Expression, you can use "0" or "0.00" in each calculation item.

(7) Are you still not using Calculation Groups?! - YouTube




Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.