Forum Discussion
Super UserNumber formatting differs between Power BI Desktop and Service (Indian comma format issue)
Hi ,
I’m using comma formatting for values/measures in my Power BI report.
In Power BI Desktop, the numbers are displayed correctly in Indian format (e.g., 12,23,444). However, when I publish the same report to Power BI Service, the format changes to the international style (e.g., 1,223,444).
Power BI Service Snapshot :
Power BI Desktop Snapshot :
I have already:
-
Changed the regional settings to English (India)
-
Tried manually formatting using DAX
But the issue still persists in the Service.
Has anyone faced this before?
Is there something I might be missing in the Service or workspace settings?
Thank you for confirming that you've already reviewed your browser settings. Since the issue remains after checking the regional settings in Power BI Desktop, Power BI Service, and your browser, the most effective solution is to rebuild the dataset from the beginning with the correct culture. Sometimes, even if you later update the model language to English (India), the dataset may still use the original culture set when the PBIX file was created. Because Power BI Service uses the dataset’s model culture for numeric formatting, it's best to close Power BI Desktop, reopen it with English (India) as the default model language, create a new blank PBIX file, reload your data, and republish the report. This will ensure the dataset is set up with the correct culture so numbers display in the Indian comma format (e.g., 12,34,567) in the Service.If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
Hi, the issue has not been resolved yet. I'm not sure who marked a solution for this post, but the problem still persists on my end.
7 Replies
rohit1991Hii AnkitaaMishra
This happens because Power BI Service does not automatically use your system’s regional settings like Desktop does. In Desktop, the format follows your local machine setting (English–India), but in Service it follows the report’s model culture or the Service/workspace locale. To fix it permanently, go to Power BI Desktop >> File >> Options & Settings >> Options >> Regional Settings and set the model language to English (India), then republish. Also check in Power BI Service >> Settings >> General >> Language and ensure it’s set to English (India). The formatting will then stay in Indian comma style (12,34,567) instead of international format (1,234,567).
- danextian
This is possibly because your browser uses a different setting. For example, even if you set the locale of your model to en-gb, this stil gets overriden by your browser's.
- AnkitaaMishra
Hi danextian , I tried changing the browser settings, but the issue still persists. Is there any way to resolve this?
v-karpurapudCommunity Support
Thank you for confirming that you've already reviewed your browser settings. Since the issue remains after checking the regional settings in Power BI Desktop, Power BI Service, and your browser, the most effective solution is to rebuild the dataset from the beginning with the correct culture. Sometimes, even if you later update the model language to English (India), the dataset may still use the original culture set when the PBIX file was created. Because Power BI Service uses the dataset’s model culture for numeric formatting, it's best to close Power BI Desktop, reopen it with English (India) as the default model language, create a new blank PBIX file, reload your data, and republish the report. This will ensure the dataset is set up with the correct culture so numbers display in the Indian comma format (e.g., 12,34,567) in the Service.If you have any further questions, feel free to reach out and we'll be glad to assist.
Regards,
Microsoft Fabric Community Support Team.
- v-karpurapud
Thank you for submitting your question to the Microsoft Fabric Community Forum. Thanks also to rohit1991 and danextian for providing helpful suggestions.
I hope the information shared helps resolve your issue. If you have more questions or need further assistance, please let us know. We're here to help.
Best regards,
Community Support Team. - v-karpurapud
We have not received a response from you regarding the query and were following up 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.
