Using FORMAT destroys table/matrix alignment

[pontushaglund]

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

[NandyFPS]

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!

[walnorez]

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

[Eric_Zhang · Accepted solution]

---

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