Currency format

[tsarun1992]

The below dashboard has two columns.

Column 2 - Default numbering format in India (Since I'm developing this from India)

Column 1 - I used certain DAX to convert the format from IN to DK numbering system.

Since column 1 is a formated one & since I cannot set this column format to "Number" I'm unable to sort it in ascending / descending order.

Is there any default option in the Power BI using which I can convert the numbering system without using any external DAXes?

[tsarun1992]

I'm sorry if I have posted with a wrong header !!

It is not the currency format, it is the number format which I am seeking help for.

Example - 1  Million in Indian format is 10,00,000 while I need it in the "DK format as 1.000.000"

[rajulshah]

@tsarun1992 

Maybe the below links can help you!

https://community.fabric.microsoft.com/t5/Desktop/Decimal-separator-point-vs-comma/td-p/1466459

]https://community.fabric.microsoft.com/t5/Desktop/Thousand-Separator-and-Decimal-Separator/m-p/19492...

Let me know if this didn't work.

[rajulshah]

@tsarun1992 

Maybe the following links can help you - 

https://learn.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

https://www.powertechtips.com/change-currency-format-power-bi/

Please let me know if this didn't help.