Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
10 years ago

Wrong Currency Symbol - SSAS MD

Hello,   I have some calculated fields in SSAS MD cube and give the format as currency. When I developed the report in Desktop, it shows the $ (Dollar Sign) as symbol but after I published the repo...
Need Help
AdelaBadea's avatar
AdelaBadea
New Member
9 years ago

Hello, I have the same issue. Do you remember what was the fix?

Braggilicious's avatar
Braggilicious
Frequent Visitor
9 years ago

Problem is SSAS DAXMD is broken and there is no commitment by Microsoft to fix the issue. 

 

Cell level value formatting is currently not supported in Power BI.  This is documented in the "Limitations of SSAS Multidimensional Models in Power BI Desktop" section of https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-ssas-multidimensional/. 

 

The only workaround is to potentially create a calculated member of your measure with the correct format.  

CREATE MEMBER Measures.[Measure1] AS Measures.[Measure1_copy],

FORMAT_STRING = "$#,##0.00;-$#,##0.00",

 

It means duplicating your measure but it seems to work for us.