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.

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.