Forum Discussion
Organizational Apps - number format
In the dataset settings, both regional settings are configured to German (Switzerland). Under Cultures, the dataset is set to de-CH for Switzerland. In Fabric, the Display Language setting is configured as Default (browser language). In Microsoft Edge, German (Switzerland) is also set as the primary language.
Despite all these settings, the Organizational Apps continue to display numbers using the German (Germany) format. The same dataset, however, is displayed with the correct Swiss number format when accessed through Workspace Apps.
Is this a bug in the new Organizational Apps, or is there another setting that Organizational Apps use that differs from Workspace Apps?
Thank you in advance for sharing your experiences and feedback on this topic.
Best regards,
dar_hubat
Hello,
I have observed what appears to be a very similar issue, but related to date formats rather than number formats.
In my case, the semantic model culture is configured as nb-NO and the report is designed to display dates in the Norwegian format dd.MM.yyyy.
The report displays dates correctly in:
- Power BI Desktop
- The Power BI/Fabric Service
- Workspace Apps
However, when the same report is accessed through an Organizational App, the date format appears to follow the Power BI/Fabric Service language rather than the locale defined in the report.
For example, when using English as the Service language, dates are displayed as MM.dd.yyyy in the Organizational App, despite the report and semantic model being configured for Norwegian formatting.
This seems very similar to the behaviour described here with Swiss number formats, where Workspace Apps respect the dataset/report culture settings but Organizational Apps do not.
i have made a seperate case on this, in case this is not the same, or i might get feedback faster.
Org Apps and date format - not showing based on se... - Microsoft Fabric Community
8 Replies
Hello dar_hubat,
This is a known issue caused by a behavioral difference between the standard Power BI Workspace canvas and the Organizational App platform container layer.While the workspace correctly reads your dataset's culture settings and your browser properties, the App platform container often relies on the core file locale or forces tenant defaults, resulting in the fallback to German (Germany) formatting (1.650,25).
How to Fix This Issue : Hardcode the File Locale in Power BI Desktop:Open your source .pbix file. Navigate to File > Options and Settings > Options > Current File > Regional Settings. Locate the option for "Default format string locale" and explicitly change it to German (Switzerland). Save and republish.Update directly via Power BI Service: Open your report in the workspace in Reading View. Go to File > Settings, find Default format string locale, change it to German (Switzerland), and save.Republish the App Layer: Once the underlying report dataset is updated, go to your workspace, click Update App, and republish the application container so the layout cache updates.This overrides browser-level guesswork and forces the Org App container to explicitly render the correct Swiss number format (1'650.25).
Best regards,
HuzaifaThank you huazifa_06 for your response and the detailed explanations. I will review this over the next few days and check whether I can switch to the desired number format using your instructions.
However, does this mean that this is still a bug in the Organizational App and that it could potentially be corrected by Microsoft in the future?
v-abhinavmuCommunity Support
Hi dar_hubat,
Thanks for reaching out to the Microsoft Fabric Community forum. and thanks to huzaifa_06 for sharing the valuable insights.
Yes, it’s reasonable to keep this under observation, especially since you’re seeing different formatting between the two app experiences.
According to Microsoft’s documentation, the Default format string locale setting is intended to control how dates and numbers are displayed in visuals. When a specific locale is selected, locale-aware format strings use that locale instead of the viewer’s browser locale.
Microsoft also documents that org apps and workspace apps are different app experiences, with some differences in supported report capabilities.
Given these documented behaviors, the difference you’re observing between the two app experiences is worth keeping under observation. If the Default format string locale is configured for German (Switzerland), the documented behavior is that locale-aware date and number formats should use that specified locale rather than the viewer’s browser locale.
For more details, please refer to the below official documentation:
Set the default format string locale for a Power BI report - Power BI | Microsoft Learn
Get Started with Org Apps - Power BI | Microsoft Learn
I hope this helps. Please feel free to reach out if you have any further questions.
Thank you.
Hi huzaifa_06
Although I followed all the steps you described, the Organizational App still displays the number format for German (Germany) instead of German (Switzerland).
Everything is configured for German (Switzerland) or "de-CH", including the shared dataset and the report settings under "Default format string locale for date and number formatting".
Additionally, after making these changes, I deleted and recreated the Organizational App, but unfortunately the result remains the same.
Has anyone else experienced the same issue and been unable to resolve it despite following the steps mentioned above? I would be interested to know whether this behavior is specific to my environment or if other users are seeing the same problem with Organizational Apps as well.
- v-abhinavmu
Hi dar_hubat,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to huzaifa_06 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Lars_SoreideAdvocate I
Hello,
I have observed what appears to be a very similar issue, but related to date formats rather than number formats.
In my case, the semantic model culture is configured as nb-NO and the report is designed to display dates in the Norwegian format dd.MM.yyyy.
The report displays dates correctly in:
- Power BI Desktop
- The Power BI/Fabric Service
- Workspace Apps
However, when the same report is accessed through an Organizational App, the date format appears to follow the Power BI/Fabric Service language rather than the locale defined in the report.
For example, when using English as the Service language, dates are displayed as MM.dd.yyyy in the Organizational App, despite the report and semantic model being configured for Norwegian formatting.
This seems very similar to the behaviour described here with Swiss number formats, where Workspace Apps respect the dataset/report culture settings but Organizational Apps do not.
i have made a seperate case on this, in case this is not the same, or i might get feedback faster.
Org Apps and date format - not showing based on se... - Microsoft Fabric Community- v-abhinavmu
Hi dar_hubat,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you. - v-abhinavmu
Hi dar_hubat,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
