I am trying to format a calculated members and measures using "Currency" format string, however this property is not being applied to the value.

I've checked other posts related to this issue that mention the problem is only seen while browsing the cube from SSDT. For my case cube browser and Excel still do not work.

Why is not format string property being applied?

This issue is only related to FORMAT_STRING property since I set color foreground property to the calculated member and it is shown in Excel client, "currency" property is not.

Below the script for calculated member creation.

CREATE MEMBER CURRENTCUBE.[Measures].GananciaBrutaTotal
 AS [Measures].[Ganancia Bruta - Fact Ventas]-[Measures].[Ganancia Bruta], 
FORMAT_STRING = "Currency", 
FORE_COLOR = 4227327 /*R=255, G=128, B=64*/ , 
LANGUAGE = 9226, //9226
NON_EMPTY_BEHAVIOR = { [Ganancia Bruta], [Ganancia Bruta - Fact Ventas] }, 
VISIBLE = 1  ;

Note language property set to 9226 Locale ID for Spanish Colombia

This is the cube language setting: Spanish (Colombia)

Client machine language setting: Spanish (Colombia)

Server machine language setting: Spanish (Colombia)

Excel language setting: Spanish (Colombia)

If your formatting is working within some tools, but not Excel, I would be looking at the connection properties for your pivottable. You should have an "OLAP Server Formatting" section, which has the option to honour 

• Number Format
• Fill Color
• Font Style
• Text Color

Check that they are all enabled on your connection.

Hope that helps,

There's a known problem with format not working when pulling the measures/ calculated members to powerpivot in Excel. However when you use normal pivot tables in excel, they work. Is this the behavior you're seeing in your case?