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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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