cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

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 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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





8 REPLIES 8
Phil_Seamark Super Contributor
Super Contributor

Re: Wrong Currency Symbol - SSAS MD

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.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super User
Super User

Re: Wrong Currency Symbol - SSAS MD

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






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Phil_Seamark Super Contributor
Super Contributor

Re: Wrong Currency Symbol - SSAS MD

Are you importing the data from SSAS or using live connect?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super User
Super User

Re: Wrong Currency Symbol - SSAS MD

Live connect 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Braggilicious Frequent Visitor
Frequent Visitor

Re: Wrong Currency Symbol - SSAS MD

Hi

 

DId you get a solution to this?  I'm getting weird formating and incorrect results from my cube via liveconnect.   It's not displaying currency measures as correctly formatted values.

Super User
Super User

Re: Wrong Currency Symbol - SSAS MD

Hey sorry for the late reply, as far as I remember, formatting worked fine, and now don't remember what was the fix, most likely it was on Cube side. Sorry for not having clear information. Let me know if you want me to dig further into it at my end.

 

Thanks,

P






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





AdelaBadea Occasional Visitor
Occasional Visitor

Re: Wrong Currency Symbol - SSAS MD

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

Braggilicious Frequent Visitor
Frequent Visitor

Re: Wrong Currency Symbol - SSAS MD

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.  

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 389 members 3,084 guests
Please welcome our newest community members: