Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago

Format Decimal Number

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 loo...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Stuznet
    Helper V
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        Stuznet
        Helper V
        7 years ago

        @@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...