Forum Discussion
Spacing between values
Anonymous
Or any other way to solve this issue? Greatly appreciated
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 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?
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 regardsHey 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