how to display only 1 digit after decimal

[Anonymous]

Hi, 

i want to change the way of data looks like, e.g., if the data is 20.00%, i want it to be displayed as 20.0%, I have used rounding formula, but it won't change the way the data are displayed. 

Thanks for help!

[Greg_Deckler]

You can change the number decimal places under either Column tools or Measure tools in the ribbon, Formatting section.

[Anonymous · Accepted solution]

As mentioned, I am trying to change the display of decimals in Excel Power Query instead of Power BI, and I don't want  to change the decimal via Excel Formatting because I want to fix all the data manipulation in Power Query (to save formatting in future when the source data is updated). I finally fix the decimal through text formula in M query. It's a bit cumbersome, but text formulas provide more flexibility in my case. 

[TomMartens]

Hey @Anonymous ,

please create a pbix that contains sample data, but still reflects your data model, upload the pbix to onedrive or dropbox, and share the link.

Don't forget to describe the expected result based on the provided sample data.

Regards,

Tom

[Anonymous]

Actually i'm using the power query add-in in Excel rather than power bi because I need to share the file with other users whose system can't read pbix files. Is it possible to manage decimal display in power query-Excel?

[FrankAT]

Hi @Anonymous ,

1.  Open Power Query editor.
2. Select the desired column.
3. Tab Transform > button Rounding in group Number Column.

Regards FrankAT