Change format to "€ 123" gives "123 €"

[kimwent]

I want to change the format of a column to: "€ Euro (€ 123)", but the column shows the format "123 €". I tried the format "€ Euro (123 €)", but then the column also shows the format "123 €". 

I already had a column with the same format and that old column does exactly what I want, there it shows "€ 123". But when I will change another column it does not work.

Is it a bug? Is there an other way to change the format?

[v-haibl-msft · Accepted solution]

@kimwent

Please download the Jan 2017 version of Power BI Desktop. This issue should has been fixed now.

Best Regards,

Herbert

[v-haibl-msft]

@kimwent

The fix will be in Power BI Jan 5th release. Please check it later.

Best Regards,

Herbert

[v-sihou-msft]

@kimwent

I reproduced your issue. No matter I select (€ 123) or (123 €), it always shows "123 €" format. We have reported this issue internally. Please also submit an issue on Idea: https://ideas.powerbi.com/forums/360879-issues

Regards,

[BhaveshPatel]

Hmm... Strange behaviour. You can try changing the format using FORMAT function.

Please visit this MSDN for the documentation for future reference.

https://msdn.microsoft.com/en-us/library/ee634206.aspx