Number Formatting

[rkamiya]

Hi all,

Just a quick question, is it possible to change the format of a decimal number in P.BI? As i tried running the same script both in P.BI and in Excel, but shows different results.

As shown on the attached screenshot. I'd be needing to have the CH_Iteration field in P.BI to show its values to the one shown in Excel. Whereas its decimal format is XX.X. 

Thanks in advance guys

[Anonymous · Accepted solution]

@rkamiya,

You are able to change the format of decimal number in Power BI Desktop. Click on the decimal field in your table in Fields panel, change Decimal places to 1 under Modeling ribbon.



Regards,
Lydia