cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MSA-SOJ Frequent Visitor
Frequent Visitor

Number format - shows american format in visuals but European everywhere else.

Hello everyone 

 

I have created a report in Power BI Desktop. It is not linked to Service. 

 

When i created the report i set the regional settings (local file) to danish, so the number and date format would be correct, but for some reason the format is only correct in the query editor and data view. When I create a visual (table), it shows the numberformat as an american format. 

 

I have Windows 10 on my computer, if that can affect the problem somehow. My regional settings in windows is set to danish as well. 

 

Datasource is an azure sql-server database.

 

I hope you guys can help me, thanks in advance

 

EDIT - SOLUTION:

It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.

1 ACCEPTED SOLUTION

Accepted Solutions
MSA-SOJ Frequent Visitor
Frequent Visitor

Re: Number format - shows american format in visuals but European everywhere else.

It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.

3 REPLIES 3
TeigeGao Super Contributor
Super Contributor

Re: Number format - shows american format in visuals but European everywhere else.

Hi MSA-SOJ,

Could you please share the screenshot to us for analysis?

Generally, the number format displayed in visual should be same in model, please try to change it in Modeling -> Formatting.

Snipaste_2019-04-02_13-52-44.png

Best Regards,

Teige

MSA-SOJ Frequent Visitor
Frequent Visitor

Re: Number format - shows american format in visuals but European everywhere else.

Hi Teige

 

Thanks for replying 

 

Here is a number of screenshots of my data, and what i have tried since i submitted the question:

 

My numbers in query editor -  the data is shown and the only steps made are source and navigation:

Here my numbers have a comma for decimals, which is what i want. 

 

query editor - european.PNGQuery editor

The the data view my numbers is also have commas for decimals. 

 

Data view - european.PNGData view

The the report view in my visuals the numbers are formattet american and have a dot for the decimals. The modelling > formatting is greyed out here. 

 

report view - american.PNGReport view

 

The things i have tried includes:

 

Format the numbers as text in query editor and using DAX VALUE() to correct it - still american format

 

Using DAX FORMAT() - kinda worked as i had commas, but formattede my numbers as text, which ruined the aggregating functions and removed the totals in my visuals. 

 

Formatting numbers as danish currency using modeling > formatting - still american format in visuals. 

 

I hope this i enough information for you to help me better.

 

Thank you alot 

MSA-SOJ Frequent Visitor
Frequent Visitor

Re: Number format - shows american format in visuals but European everywhere else.

It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.