Forum Discussion
Spacing between values
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
14 Replies
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
Thejeswar Thanx for your effort, but it didnt unfortunately work. I get the same result
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,
LydiaAnonymous,
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 SpacedNumTextAnd 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 SpacedNumTextTo achieve what I believe you are after, see below:
Does that work for your needs?
