Skip to main content
cancel
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.

Reply
Energy2k8
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: 

Energy2k8_0-1633947760774.png

 

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:

Energy2k8_1-1633947860351.png

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 2
v-yangliu-msft
Community Support
Community Support

Hi  @Energy2k8 ,

You can change it to Whole number format.

vyangliumsft_0-1634191553275.png

 

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
Employee
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

 





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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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