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 separat...
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.

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