SWITCH DAX returning both text and numeric values — numeric values show left-aligned as text

Hi everyone,

I created a SWITCH DAX measure that returns a mix of text and numeric values depending on conditions.

Example:

Result =

SWITCH(

TRUE(),

Table[Status] = "A", "Approved",

Table[Status] = "P", "Pending",

Table[Status] = "N", 1200,

Table[Status] = "X", 980,

BLANK()

)

The measure works, but Power BI treats the entire column as text, so numeric values appear left-aligned and behave like text.

I tried using FORMAT() and changing visual alignment, but I want a solution where numeric values appear right-aligned like numbers while still keeping text for other conditions.

Is there any way to:

Keep the mixed output from SWITCH, and

Make numeric values display as numeric (right-aligned) in the same column?

Any ideas or workarounds would be appreciated!