Forum Discussion

Igorfm7's avatar
Igorfm7
Copper Contributor
Jan 22, 2024

I want to change all this values

 

RankNamePlatformYearGenrePublisherNA_SalesEU_SalesJP_SalesOther_SalesGlobal_Sales
1Wii SportsWii2006SportsNintendo41.4929.023.778.4682.74
2Super Mario Bros.NES1985PlatformNintendo29.083.586.810.7740.24
3Mario Kart WiiWii2008RacingNintendo15.8512.883.793.3135.82
4Wii Sports ResortWii2009SportsNintendo15.7511.013.282.9633
5Pokemon Red/Pokemon BlueGB1996Role-PlayingNintendo11.278.8910.22131.37
6TetrisGB1989PuzzleNintendo23.22.264.220.5830.26


I want this values for example:
41.49 as 41.490
29.02 as 29.02
3.77 as 3.770

I have downloaded a csv from internet to use in my classes of Power BI and I need to change this values because I think the owner of the archive done that with just 2 decimals because he didn't wanted to use this as I want to.

Could anyone help me out with this?

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Igorfm7 I believe your system uses comma as the decimal separator. That's why most of the numbers are left aligned and you can't increase the number of decimals. They are seen as texts.

    You mention Power BI. Then I suggest you use Power Query (also part of Power BI) to transform the texts that look like numbers to suite your locale.

    When I copy the data from your post I get numbers directly as my system uses the point for decimals. See attached. When you open that file it should be automatically 'translated' into numbers for you also.

     

    • Igorfm7's avatar
      Igorfm7
      Copper Contributor
      So how do I do to change all the lines and collumns?
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        Igorfm7 Well, if you don't know about or don't want to use Power Query despite the fact you work in Power BI, you can select (in Excel) all the 'number columns' and then Ctrl-H (Find & Replace) and replace decimal point with comma. 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Right-click, format cells, Number category, set to 3 decimals?
    • Igorfm7's avatar
      Igorfm7
      Copper Contributor
      No, because the numbers are on text format.

Resources