0

I am doing a dynamic stock quote in Power BI and I want to pull data on stocks with various currencies. My issue is then when I pull the numbers, the comma is missing: enter image description here

instead of being 86,699997 it deletes the comma so that the value is just 86699997 - does anyone know how to overcome this when extracting the data?

Yehor Androsov
  • 4,885
  • 2
  • 23
  • 40
Sophie Rønnstad
  • 13
  • 1
  • not familiar with power bi, but it is common issue when comma is used as thousands separator, not decimals. maybe you have to find some way how to switch decimal separator from dot to comma – Yehor Androsov Mar 29 '22 at 09:23
  • In Power Query, add the `culture` argument to the `Change Type` step -- probably should be `"en-US"` – Ron Rosenfeld Mar 29 '22 at 10:51

0 Answers0