Forum Discussion
larsvedoy
8 years agoFrequent Visitor
Wrong decimal seperator
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
2 Replies
- v-yulgu-msft
Microsoft Employee
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
- larsvedoyFrequent Visitor