Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 ...
Custom Visuals
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous

    Or any other way to solve this issue? Greatly appreciated

     

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        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