topic Re: Format values in Norwegian with space as thousand separator in DAX Commands and Tips

Format values in Norwegian with space as thousand separator

Puja_Kumari25 — Wed, 19 Mar 2025 20:36:07 GMT

Hi Experts,

Please help me format mesures values in Norwegian with space as a thousand separator. we have to show a measure gauge chart, bar chart and tabular visual.

I have uploaded a sample file at the location :

https://drive.google.com/file/d/1dBk0QdRc2fSic7CFYb8HjI-Vpy2uTM5u/view

Re: Format values in Norwegian with space as thousand separator

OwenAuger — Wed, 19 Mar 2025 23:35:55 GMT

Hi Puja_Kumari25

Without playing with any regional settings, you could set the format string for the measure (or column if using implicit measures) to:

### ### ### ### ##0

From what I can gather, the use of a non-comma thousands separator does not automatically "scale", so you would have to include enough "#" placeholders to accommodate the most digits that will need to be displayed.

Variants to handle decimals and units of thousands or millions should also be possible.

Would something like this work?

Re: Format values in Norwegian with space as thousand separator

Puja_Kumari25 — Thu, 20 Mar 2025 07:04:38 GMT

Hi, Could you please help me with the sample solution, I have attached pbix

Re: Format values in Norwegian with space as thousand separator

OwenAuger — Thu, 20 Mar 2025 09:28:13 GMT

Hi again Puja_Kumari25

No problem, I have attached your PBIX with some updates.

1. Order Value

### ### ### ### ##0;-### ### ### ### ##0;0

Standard format string entered in the Measure tools > Format box.

2. Order Value Dynamic

An example of a dynamic format string.

Measure tools > Format > Dynamic:

-- Sample number format handling millions VAR BaseFormat = "### ### ### ### ##0" VAR MeasureValue = SELECTEDMEASURE () VAR MeasureValueAbsolute = ABS ( MeasureValue ) VAR Result = IF ( MeasureValueAbsolute >= 10^6, -- Format for absolute values >= 10^6 BaseFormat & "M,,;-" & BaseFormat & "M,,;0", -- Format for smaller absolute values BaseFormat & ";-" & BaseFormat & ";0" ) RETURN Result

Hope that helps!

Re: Format values in Norwegian with space as thousand separator

Puja_Kumari25 — Thu, 20 Mar 2025 19:51:36 GMT

Hi , Thanks alot

this solution is working

Thank you!

Re: Format values in Norwegian with space as thousand separator

Puja_Kumari25 — Thu, 20 Mar 2025 21:09:52 GMT

Hi,

can we comma as decimal place like- 272 556 .80

272 556 ,80

Re: Format values in Norwegian with space as thousand separator

Puja_Kumari25 — Thu, 20 Mar 2025 22:46:42 GMT

Hi,

can we replace comma as decimal place like- 272 556 .80

272 556 ,80

Re: Format values in Norwegian with space as thousand separator

OwenAuger — Thu, 20 Mar 2025 23:13:47 GMT

I'm afraid I don't know how to do that. I'm pretty sure it can't be controlled through the format string and would involve some regional settings.

I suggest posting that question in a new thread to see if anyone has any suggestions.