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

Formattting numbers in Swedish format

I need to format numbers with space as thousand-separator and a comma as decimal-separator. Im very close but cant seem to get it working all the way:

 
Format( Sum( SalesOrderRow[Sales Amount] ) / SelectedValue( '__ShowThousands'[DivideBy] ), "### ### ##0\,.00" )
(DivideBy is 1 or 1000 depending on user preference).
 
This gives: 245 342,.32 if the original value is: 245,342.32 when DivideBy i 1 (if Divide by is 1000 then the result shows: 245,.34). The problem is that if i remove the dot in the format string everything gets messed up - and I dont want the dot in the end result obviously.
(I need the rest of the environment in english so I cant change culture - so that's not the solution unfortunately.)
Thanks!
3 REPLIES 3
Highlighted
Super User III
Super User III

Re: Formattting numbers in Swedish format

@bjernersjo 

Is this what you want?

Column = FORMAT('Table'[Column1]/1000,"# ### ###.##")

1.PNG

Did I answer your question? Mark my post as a solution.Appreciate your Kudos!
Proud a to be a Datanaut!
Thanks and BR
Ryan
Highlighted
Super User IX
Super User IX

Re: Formattting numbers in Swedish format

Highlighted
Community Support
Community Support

Re: Formattting numbers in Swedish format

Hi @bjernersjo,

Power bi desktop uses the number format as your system region and currency symbols settings.
You can refer to amitchandak's links to modify them in your system settings but they will also affect the general numeric values stored in your system.

For format function, it will convert your number to text and display it with the specific format that you defined in the optional parameters.

I'd like to suggest you try to do formatting in your table field properties, it only changes the display value format and not affect the raw record values:

Use custom format strings in Power BI Desktop 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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