Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Quotes imported to Power BI without decimal points

The quotes are being imported into Power BI withou decimal points:

117.965856 turns into 117.965.856,00
1269.305868 turns into 1.269.305.868,00

Therefore my portfolio value is overestimated by a lot! On the Excel spreadsheet on the other hand it works fine.

How can I configure the decimal point in the Power BI ?

In the PSConfig file I have the following:

# ColumnSeparator values could be : Comma, Tab, VerticalBar

Tab


# DecimalSeparator: Default value is . (dot), in some coutries this could be , (comma)

,

Comments

  • Open PortfolioSlicer PowerBI file, then go to File->Options and Settings->OPtions->Current File, Regional Settings and change them to match your region. Restart and please let me know if that helps.
  • Thanks! That worked
Sign In or Register to comment.