cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
larsvedoy Frequent Visitor
Frequent 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 2
Microsoft v-yulgu-msft
Microsoft

Re: Wrong decimal seperator

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
larsvedoy Frequent Visitor
Frequent Visitor

Re: Wrong decimal seperator

Hi, @v-yulgu-msft,

 

It's decimal number.

 

Lars

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,554)