Changing Format of Measure for currency

[NadeemAhamed]

Dear All,

Greetings!

I have created measures which is automatically format is text. 

i want to apply comma in measures for number for all DAX.

is it possible to apply comma for first after 3 decimal then for all after 2 decimal. 

EX: 1. 23,000

      2. 2,12,244

      3. 23,23,445

2nd measures: I have created measures with switch terms to fetch the values based on slicer. but for this measures i am failing to apply format.

Thanks in advance. 

[lbendlin]

Indian number format can be handled by specifying it explicitly

Solved: INDIAN CURRENCY VALUE FORMAT - Microsoft Fabric Community

[NadeemAhamed]

Dear @lbendlin 

Thank you for your valuable time to read and reply.

I have gone through the above solved formate but for me its not working.

for your reference i have attached the excel and .pbix file

I have 2 vistual. matrix and card but in both is not showing as per requirement. 

I hope you have the access and got my query. 

Pbix: https://toyotsu.box.com/s/590uj8gf4gs229xtmzu4popa8m447mme

Excel: https://toyotsu.box.com/s/iv40ihwk157fl7ev31x1qrtmpexhvdyh

[lbendlin · Accepted solution]

Your data is not in a suitable format. You need to first unpivot it.

From

to 

That will remove the need for all the measures you created.  Then you need to apply the formatting only to the plan/actual items.

I'll leave the month sorting as an exercise for you.