Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
larsvedoy
Frequent Visitor

Wrong decimal seperator

‎02-12-2018 03:54 AM

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

Labels:
Message 1 of 3
779 Views
0
2 REPLIES 2
v-yulgu-msft
Employee
Employee

‎02-14-2018 01:30 AM

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.
Message 2 of 3
749 Views
0
larsvedoy
Frequent Visitor
In response to v-yulgu-msft

‎02-14-2018 03:25 AM

Hi, @v-yulgu-msft,

 

It's decimal number.

 

Lars

Message 3 of 3
743 Views
0

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All