Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Currency Formatting with space for proper alignment

Hi,

 

i'm trying to find a way to reproduce an excel formatting in the PowerBI Table.

In excel the formatting would be something like $* #.##. Which would allow all the currently symbols to be left justified while the amount would be right justified

Ex:

 

$      1.23

$    12.34

$  123.45

 

I couldn't find a way, it seems the current currency / custom formatting doesn't support the * function

 

Thanks