Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Card Currency Symbol Formatting Issue

When a field is formatted to be currency (In my case I have formatted the field to be Indian currency) and displayed as a card, the currency symbol gets displayed at the end of the number. Power Bi Formatting Issue.jpg

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi @sushil088,

 

Since you have a right one, what happened to the other one? 

1. Is it a measure or a calculated column? What's the formula?

2. Are they all simple card?

3. How can I reproduce it?

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
yachanagupta
Frequent Visitor
measure = IF([column name]>10000000,
format([column name]/10000000,"₹ ##0.0 Cr"),
if([column name]>100000,format([column name]/100000,"₹ ##.0 L"),[column name]))
Raja10ram
Frequent Visitor

 

I am Facing some issue in currency format in power bi. How can i fix that issue. I have show the currency as Indian format in desktop its works, But when i published it to the client then it showing as million format.

 

Below images for your quick reference.

 

First Image Shows in Desktop:Indian Currency is showing Power BI DesktopIndian Currency is showing Power BI Desktop

After Published to the Client it shows in USD format:

 

It Showing this format after published to the client.It Showing this format after published to the client.

 

Much appreciated your support.

 

Thanks,

Ramjee.