Forum Discussion
Super UserWrong 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 report PowerBI Service, it is showing sterling pound currency symbol. Not sure what I need to do to change the symbol.
Just to add, you cannot do anything with data model when using SSAS MD.
One solution I can think of is to change the format from "Currency" to something like this "$#,##0.00;-$#,##0.00", not sure if it will fix.
Any solution or it is just a bug?
Thanks,
P
8 Replies
- Phil_Seamark
Microsoft Employee
You can try setting the Locale to something and see if that works.
From Power BI Desktop, File -> Options and Settings -> Options -> Data Load
And set the Locale to something there and see how that works.
- parry2k
Hello,
I tried but no success. Changed it to "English (United States)", I read the little blurb by hovering to (i) next to Locale label and it shows that "Regional setting used to interpret number, date, etc... in imported text from the file". So based on it I'm assuming this locate setting is not doing anything when I'm using currency from SSAS.
Thanks,
Parvinder
- Phil_Seamark
Are you importing the data from SSAS or using live connect?
