Regional number formatting

[anpilost]

Hi, I want to apply the Swiss regional number format on my Power BI report, but it is not working for the FinancialReportingMatrix. All the other visuals in the report automatically apply the regional number setting, but not the FinancialReportingMatrix. The Swiss number format is as follows: thousands separator = ‘ inverted comma (e.g 1’500); Decimal separator = . dot (e.g. 1’500.99). Is there a way to apply the regional number format? Thanks for your help

[toresenneseth]

We are just using the formatting API provided by Power BI, so all format strings and regional settings should be picked up automatically. There are differences between what API's are available to custom visuals and built-in visuals, if that's what you are comparing against?

[anpilost]

The problem is, that the built-in visuals are picking up the regional setting, but the FinancialReportingMatrix isn't. At least not for the Swiss setting. Is there a way to change the format string manually inside the FinancialReportingMatrix?

[toresenneseth]

The Financial Reporting Matrix is using the formatting API provided by Power BI, and picking up the regional settings, but it might be that the formatting API available to custom visuals does not handle certain format strings or cultures. The built-in visuals is using a different API, which is not available to custom visuals. We will look into this and see what we can figure out.

[toresenneseth]

Same as issue #179 Did you try to change the regional settings in Power BI Desktop or in the browser?

[Javier-san]

I had the same issue. As there is no language setting as [Deutsch (Schweiz)] using [Deutsch (Deutschland)] uses the wrong formatting. Use [Windows-Standardanzeigesprache verwenden] as long as your OS is set to [Deutsch (Schweiz)]. I guess the same applies to Italian and French (Switzerland).

[hakiow]

I've got a similar issue, which I cannot figure out. In short, I just wanna have the ProfitBase visual present numbers with DOT as thousand-separator, and COMMA as decimal-separator.

My Windows Regional settings are Denmark (Danish). My PowerBI report is inheriting these, and default visuals shows the numbers as I like when a Measure is a decimal/number with 2 decimals and the thousand-separator enabled.

But I cannot get the Profitbase to show the same. Using the Value Default formatting shows COMMAS as thousand-separator. I've tried a lot of different formats-syntaxes, but I cannot make it work.

See below:

[hakiow]

@toresenneseth would you might have some inputs for this? I'm DK-based, so you guys in the North should have had the same needs, to present numbers with . as thousand-sep, and comma as decimal :)?