Forum Discussion

pontushaglund's avatar
pontushaglund
Helper I
8 years ago
Solved

Using FORMAT destroys table/matrix alignment

I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

Am I missing something?

 

Thanks in advance,

 

Pontus

Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago
    pontushaglund wrote:

    I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

    Am I missing something?

     

    Thanks in advance,

     

    Pontus

    pontushaglund

    I think it is all by design. Using FORMAT converts data to text type. text is left-aligned while numbers are right aligned.

3 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    pontushaglund wrote:

    I have a "varible" measure that uses SWITCH to decide what measure to show in a table. In the case of YoY% versus VTB I want the result to be percentage rather than Whole number with thousand separator. Using the FORMAT everything gets left-aligned in the matrix (and table) visuals rather than right-aligned (which looks a lot better for numbers).

    Am I missing something?

     

    Thanks in advance,

     

    Pontus

    pontushaglund

    I think it is all by design. Using FORMAT converts data to text type. text is left-aligned while numbers are right aligned.

  • walnorez's avatar
    walnorez
    Regular Visitor
    2 years ago

    Yes, the FORMAT transforms numbers to text format, but you can still align it to the right. 

    Go to Format your visual tab >> Specific column >> choose the column where you use FORMAT function and choose alignment that you need (to the right in this example). 

    Done

  • NandyFPS's avatar
    NandyFPS
    Frequent Visitor
    2 years ago

    Using format will convert to text and you may not be aware but you will also not be able to plot the resulting values to any charts. You can use the new Dynamic format type located in measure tools to the same effect, however this will format without converting to text and hence allow plotting to charts!