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.

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!