Spacing between values

[Anonymous]

Hey, 

I have some values ​​like 13000 14500 12400, I'd like to have spaces between the values. So that those values ​​appear 13 000, 14 500, 12 400. Initially, I have a table visalization, but if I have another visalization later on, can i format the values with a space there to?

Is it a dax formula or something that can be used here?


Hope this was clear to understand

thank you in advance

[Anonymous]

There are answers here:

https://community.powerbi.com/t5/Desktop/How-do-I-add-a-space-as-a-thousand-separator-in-power-bi/td...

and here:

https://community.powerbi.com/t5/Desktop/How-to-format-data-numbers-to-Canadian-French-currency-form...

[Anonymous]

@Anonymous,

You would need to add France language to your browser, and then setting language setting in Power BI Service to "Default(browser language)".

There is a similar thread for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Thousand-Separator-and-Decimal-Separator/td-p/136397/page/2


Regards,
Lydia

[Anonymous]

@Anonymous

Or any other way to solve this issue? Greatly appreciated

[ChrisMendoza]

@Anonymous,

I converted the values to TEXT and then formatted the space in a calculated column as:

Formatted Space = 
VAR NumText = FORMAT(TableName[Values],BLANK())
VAR Right3 = RIGHT(NumText,3)
VAR LeftNums = SUBSTITUTE(NumText,Right3," ")
VAR SpacedNumText = COMBINEVALUES(" ", LeftNums, Right3)

RETURN SpacedNumText

And then applied similar to a MEASURE as:

Formatted Sum of Values = 

VAR measureSum = SUM(TableName[Values]) 
VAR NumText = FORMAT(measureSum,BLANK())
VAR Right3 = RIGHT(measureSum,3)
VAR LeftNums = SUBSTITUTE(measureSum,Right3," ")
VAR SpacedNumText = COMBINEVALUES(" ", LeftNums, Right3)

RETURN SpacedNumText

To achieve what I believe you are after, see below:

Does that work for your needs?

[Anonymous]

Hey again @ChrisMendoza,

Did try yout solution, but unfortunately it's only dependent on being used on table / matrix, can not be used on other visualizations.

[Anonymous]

@Anonymous,

The measure that ChrisMendoza created is text value, it is not possible to drag the measure to Values section of column/bar chart

Regards,
Lydia

[Anonymous]

@ChrisMendoza

Hey, thanx for ur suggestion. Will try it out.
But will this only be apply to a table/matrix visualisation.
For example I have a clustered column chart, when I am pointing over with the mouse, will it then be spacing in the values that will be displayed or on the columns itself? 
Can it be reused on other visualisations as well?
best regards

[Anonymous]

Hey, 

I have read through the thread, thanx.  But as I see the end result did not get any different for her there too. Are you sure that there is no dax formula to solve this?

@Anonymous

[Anonymous]

hey, 

Is there no one out there who has a solution? 

[Thejeswar]

@Anonymous,

I think changing location in desktop is not a right solution.

Because eventually as @Anonymous stated, when published to service, the setting of the service will take over.

Setting location inside PBIX File, might help. But not sure.

@Anonymous, please change the location in Regional Settings of your PBIX file and try publishing in service. 

PFB the image

Regards,

Thejeswar

[Anonymous]

@Thejeswar Thanx for your effort, but it didnt unfortunately work. I get the same result

[Anonymous]

@Anonymous,

You can change region or your computer to France, this way, after you turn on thousands separator in Power BI Desktop, you will get space between numbers as you expect.



Regards,
Lydia

[Anonymous]

Hey, 

Thanx alot for your help. This works great. But a problem, when I am uploading the pbix file in the power bi service, the values have a comme istead of space? 

[Anonymous]

@Anonymous