Format Decimal Number

[Stuznet]

I can change the number format in Excel but How do I round the number to oneth in Dax? 

 Sum column is what I want to round to the Oneth, so the result in the Rounded column is what I'm looking for.

 

Thanks much

[Anonymous]

Hey @Stuznet

You have 2 options to accomplish this. If your number will always be formatted with 1 decimal place, go to the Modeling tab and you can set the number of decimals you want by changing "Auto" to 1. This is found in the section where you set the Data type and format.

If your requirements require you to set the number of decimals dynamically, you can do that by changing the value to text and specifying the number of decimal places. If you're interested, see this video I just posted on exactly that.

https://www.youtube.com/watch?v=FO6e3rjSslQ

Hope this helps,

Parker

[Stuznet]

@AnonymousThank you for your response, I have already tried that approach but is not working for me. So basically I'm only looking for the initial number that is rounded. 

[Anonymous]

@Stuznet

If you are using a matrix visualization or maybe even a table, you can specifically set the decimal places of the column by going editing the Field Properties.

-Parker

[Stuznet]

@@Parker_Steven I'm not following what you mean. Sorry I'm kinda new to Power BI. But I thought Field Properties is only for comment...

[Anonymous]

@Stuznet Sorry, not Field properties. Go to the Formatting pane and go down to Field formatting. There you can set the decimal places.

-Parker