Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Format with "." as thousand separator and "," for decimals

Hi,

 

I'm living in Denmark wher we use "." as thousand separator. When i use

 

format(MEASURE, "#,##0")
 
i get a thousand separator with ",". 
 
How can i convert this to "."?
 
Best regards
1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @Anonymous,

You can try to use custom formatting string on your formula to modify the displayed format:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

View solution in original post

3 REPLIES 3
ribisht17
Community Champion
Community Champion

Hi @Anonymous 

 

Refer > https://community.fabric.microsoft.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/m-p/194928

 

The display of numeric felds (and dates, times etecetera) depends on your Regional Settings.

 

It can be adjusted in Power BI Desktop or in Windows (Land/Region). It looks like the Windows setting is leading, but you have to close and reopen your pbix file after adjusting the Regional Settings.

 

ribisht17_0-1704361336459.png

 

 

In Power BI you can also adjust your language settings to influence the display format for published reports.

 

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Anonymous
Not applicable

Thanks for the reply. 

I already have my settings in danish. The problem occurs because I have made a measure which returns a string.:

Kioskkunder faktisk og budget =
var faktisk = [Kioskkunder]/1000
var budget = [Kioskkunder budget] /1000
return
format(faktisk, "#,##0") & " | " & format(budget,  "#,##0")

How do i, in the format function, alter to the correct format? 
Anonymous
Not applicable

HI @Anonymous,

You can try to use custom formatting string on your formula to modify the displayed format:

Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.