Needed to Change the value displayed, separated by comma as millions , thousands and trillions

[featzsoft]

In Genrated KPI through card and charts we can see that the values unit displayed in thousands , millions and trillions, which is in american format, eg: total sale value is: 100,000.
but I needed the values to displayed in the units that support indian format of separating the zero's in thousands , lakhs , crores which is for eg : total sale value: 1,00,000.

the above method I can acheive by formatting the comma separations through dax query but it turns the integer value nto string thus gets displayed only in tables and cards,

I needed the above mentioned format to get applied in integer values so that I can use it in charts as metrics since metrics accepts only integer or float not the string.

[fahadqadir3 · Accepted solution]

@featzsoft Review the attached screenshot and Dynamic Format String to achieve your desired result.

if([AMOUNT]>100000,"##\,##\,##0","##,##0")

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

[Anonymous]

Hi @featzsoft ,

Please refer this document: Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Hope it is helpful for you.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.