Quotes imported to Power BI without decimal points

fbleitao

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)

,

VidasMatelis

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.

fbleitao

Thanks! That worked