Formatting SSAS values (Live connection/explore live)

Using the live connection to an SSAS cube I could not append a Euro symbol on a column within a table, so i created a measure which is equal to that column and added the Euros symbol and also removed the unnecessary decimals and it worked fine, but when i save the report and reopen it, it reverts all the modification i have done. Can someone help me out with this one thanks