Issue with decimal and thousands separator. Tried everything.

[jatejedor]

Hi

I have read everything on forums about this problem but the solutions don't work for me.

I'm writing from Spain. We use "." as thousands separator and "," for decimals.

This report should show about 19 hours on this colum.

I already changed column format and it appears ok on the data visualization.

 

I "refreshed" data.

I also changed regional settings on Power BI to USA.

The report is still showing wrong values.

Any idea?

[Salvador · Accepted solution]

Hello,

I'm Spanish, and had the same issue.

Instead of changing the computer's regional settings, what I did was changes in the pbix file options, as shown on the screenshots

 

[jatejedor]

Now I can see the numbers in in the right format.

but loot at the first two rows. The sum is 14,5.

If I use the sum function I get this: 54,5

Any idea?

[Salvador]

Hello,

hmmm could you add a screenshot from the data view, modeling? 

[jatejedor]

Good point. You are right. There is more data on the data view. 

[v-jiascu-msft]

Hi @jatejedor,

Did you try to change the formats in the local computer as the picture showed (in the Control panel)? Maybe this is what you want.

Best Regards!

Dale