Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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,
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?
Proud to be a Super User!
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,
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
@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
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?
@v-yuezhe-msft
hey,
Is there no one out there who has a solution?
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 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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |