cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Re: Thousand-Separator-and-Decimal-Separator

Helle all,

 

Thanks to this blogpost I have found a sulution for this problem without changing the locale for the whole Power Bi file. The steps are:

 

  1. Go to the Power Query-editor and select the column
  2. Change the data type to "decimal number" in the transform menu
  3. Open the advanced editor and add the desired locale string to the "Table.TransformColumnTypes" function.

Example:

 

#"Type gewijzigd" = Table.TransformColumnTypes(#"Kolommen verwijderd",{{"sales.grand_total_month", type number}}, "en-US")

Highlighted
New Member

Re: Thousand-Separator-and-Decimal-Separator

The Thousand Separator could not work, if the currency value contains more than 8 digits. Provide solution for this. 

Highlighted
Frequent Visitor

Re: Thousand-Separator-and-Decimal-Separator

Hello,

 

We have a power bi report embedded int .net application. We have given ($)United States format for one column in the report. It shows $123,345,678(Right format) in few browsers and machines and $12,33,45,678(wrong format) in few browsers.

 

Can some one help me to fix this please.

 

Thanks,

Power BI Learner

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors