Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jalaomar
Helper IV
Helper IV

removing comma separator

Hi all,

 

I am creating some reports related to financial data and when i format the fields numbers they look good in Power BI desktop 

 

2021-05-31_15-40-59.png

 

But when I publish the report to Power BI services, the figures have added commas, which i would like to hide and only show as in picture 1. see below pic

2021-05-31_15-40-35.png

 

Does anyone know how to have the same look and feel as in Power BI desktop?

 

Thanks!

 

BR

J

3 REPLIES 3
Fowmy
Super User
Super User

@jalaomar 

Power BI Desktop takes the date format from the local machine. Please check how you have applied the format. Did you do it using custom format in Power BI or changed the default formatting in your machine?


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi @Fowmy 

 

did not change anything really in my local setting or else 

i made changes now but did not have the desired outcome, now the comma seperator appear in the Power BI desktop as well....

could you guide to the default local setting for this issue to be fixed?

 

Many Thanks!

 

BR

J

You could try to change PBI Report Locale settings from Options -> Current File -> Regional Settings ->XXX to XX

V-lianl-msft_0-1622616075616.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.