Jan 22 2024 07:54 AM
Rank | Name | Platform | Year | Genre | Publisher | NA_Sales | EU_Sales | JP_Sales | Other_Sales | Global_Sales |
1 | Wii Sports | Wii | 2006 | Sports | Nintendo | 41.49 | 29.02 | 3.77 | 8.46 | 82.74 |
2 | Super Mario Bros. | NES | 1985 | Platform | Nintendo | 29.08 | 3.58 | 6.81 | 0.77 | 40.24 |
3 | Mario Kart Wii | Wii | 2008 | Racing | Nintendo | 15.85 | 12.88 | 3.79 | 3.31 | 35.82 |
4 | Wii Sports Resort | Wii | 2009 | Sports | Nintendo | 15.75 | 11.01 | 3.28 | 2.96 | 33 |
5 | Pokemon Red/Pokemon Blue | GB | 1996 | Role-Playing | Nintendo | 11.27 | 8.89 | 10.22 | 1 | 31.37 |
6 | Tetris | GB | 1989 | Puzzle | Nintendo | 23.2 | 2.26 | 4.22 | 0.58 | 30.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?
Jan 22 2024 08:06 AM
Jan 22 2024 08:09 AM
Jan 22 2024 08:11 AM
@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.
Jan 22 2024 08:14 AM
Jan 22 2024 08:26 AM
@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.
Jan 22 2024 08:44 AM
@Igorfm7 What does that mean "It doesn't work"? What did you try exactly?
Jan 22 2024 08:50 AM
Rank | Name | Platform | Year | Genre | Publisher | NA_Sales | EU_Sales | JP_Sales | Other_Sales | Global_Sales |
1 | Wii Sports | Wii | 2006 | Sports | Nintendo | 41,49 | 29,02 | 3,77 | 8,46 | 83 |
2 | Super Mario Bros. | NES | 1985 | Platform | Nintendo | 29,08 | 3,58 | 6,81 | 0,77 | 40 |
3 | Mario Kart Wii | Wii | 2008 | Racing | Nintendo | 15,85 | 12,88 | 3,79 | 3,31 | 36 |
4 | Wii Sports Resort | Wii | 2009 | Sports | Nintendo | 15,75 | 11,01 | 3,28 | 2,96 | 33 |
5 | Pokemon Red/Pokemon Blue | GB | 1996 | Role-Playing | Nintendo | 11,27 | 8,89 | 10,22 | 1 | 31 |
I don't want that like this.
What i want is:
Rank | Name | Platform | Year | Genre | Publisher | NA_Sales | EU_Sales | JP_Sales | Other_Sales | Global_Sales |
1 | Wii Sports | Wii | 2006 | Sports | Nintendo | 41,490 | 29,020 | 3,770 | 8,460 | 82.740 |
2 | Super Mario Bros. | NES | 1985 | Platform | Nintendo | 29,080 | 3,580 | 6,810 | 0,770 | 40,240 |
3 | Mario Kart Wii | Wii | 2008 | Racing | Nintendo | 15,85 | 12,88 | 3,79 | 3,31 | 36 |
4 | Wii Sports Resort | Wii | 2009 | Sports | Nintendo | 15,75 | 11,01 | 3,28 | 2,96 | 33 |
5 | Pokemon Red/Pokemon Blue | GB | 1996 | Role-Playing | Nintendo | 11,27 | 8,89 | 10,22 | 1 | 31 |
Look at the first two lines.
Jan 22 2024 08:52 AM
Jan 22 2024 08:58 AM
@Igorfm7 I understood that, but you need to transfer the texts to numbers first. Did you do the Find & Replace as I suggested? Did you change the column format to Numbers?
But perhaps we need to go back to square one. How did you import the CSV? just by double clicking on the file or a did you you use the text wizard?
Jan 22 2024 09:14 AM
@Riny_van_Eekelen
I'll send a video.
Look, i don't want to see numbers with 2 decimals, btw i want to see them as xx.xxx just, because i guess the owner of the csv made that in thousands and don't wanted to make ''right'' the xx.xx.
https://youtu.be/JVMrV6xTxcE
Jan 22 2024 09:44 AM - edited Jan 22 2024 09:45 AM
@Igorfm7 I looked at the video. Although it quite difficult to see, I believe you did find & Replace and formatted columns G:K as Numbers. Now you need to format the number to show three decimals.
Or if the numbers are in thousands and you want whole numbers, just multiply the lot by 1000.
If that's not what you want, I don't know anymore.