Forum Discussion
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.
2 Replies
- mahoneypat
Microsoft Employee
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
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.
