Wrong decimal seperator

[larsvedoy]

I'm struggelig to get Power BI to show commas as decimal seperator. I haven't had this problem before, so I'm quite pussled to the cause of this.

In "edit queries mode" values show correctly eg. 5,3 - but in data view it comes up with 5.6. Both my regional settings in Power BI and my Windows settings are set to Norway - so comma should be the default decimal seperator.

Hoping someone can help.

Lars

[v-yulgu-msft]

Hi @larsvedoy,

Please check the data type of this column in Query Editor to see if it is text or numeric.

Power BI: Decimal separator in your datasets

Regards,

Yuliana Gu

[larsvedoy]

Hi, @v-yulgu-msft,

It's decimal number.

Lars