Wrong Indian Currency Format in BI Services

[bhavanaShenoy]

Hello Team,

I have a amount field to be displayed in Indian Currency Format.

After viewing in BI Services, it appears as 123,456,000.

But Indian Currency is 12,34,56,000.

So, used a solution from Community as

Measure :=

VAR YourValue = SUM(Tabelle[Spalte "1"])

RETURN

SWITCH(TRUE(),

YourValue >=10000000, FORMAT(YourValue,"##\,##\,##\,##0"),

YourValue >=100000, FORMAT(YourValue,"##\,##\,##0"),

FORMAT(YourValue,"##,##0")

)

This is very useful in tiles and Reports, but not on graphs and pie charts.

When I use the measure in Bar Graph or Pie Chart, it displays blank.

How do we resolve it? 

A quick fix or solution will be appreciated.

Thanks

[amitchandak · Accepted solution]

@bhavanaShenoy , Try there - In model view - properties

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

also check regional setting

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

[bhavanaShenoy]

Thank you @amitchandak .

The Advanced Settings on Google Chrome did work out.