Scientific notation when changing decimals in field formatting

[Energy2k8]

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.

[v-yangliu-msft]

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.

[mahoneypat]

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

Pat