Decimal places in Dataflow

[Tillyz]

Hi all,

I am creating a series of index in dataflow. Everything works well when data type is text (please see the example as per below)

However, when i changed data type from text to decimal number. Index 2.10 became 2.1.

Is there any way that I could set the decimal places to 2? 

Thanks for your help.

Kind Regards,

Tilly

[v-jingzhang]

Hi @Tillyz 

In Power Query it doesn't support to format the columns. You need to format the decimal places in the model with Power BI Desktop or with Datamart in Power BI Service. When you display the data in a visual, you will see numbers with 2 decimal places. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Mahesh0016]

@Tillyz  you need to format as Decimal number then after (.) given 2 for display 2 digit of number after point(.) in power bi desktop! THANK YOU!!