Format values in Norwegian with space as thousand separator

[Puja_Kumari25]

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

[Puja_Kumari25]

hi 

Hi, 

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

                                                            272 556 ,80  

[OwenAuger]

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?

[Puja_Kumari25]

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

[Puja_Kumari25]

Hi, 

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

                                                            272 556 ,80   

[OwenAuger]

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.

[OwenAuger · Accepted solution]

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!

[Puja_Kumari25]

Hi , Thanks alot 

this solution is working 

Thank you!