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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

       

      -Parker