Forum Discussion
I want to change all this values
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 ...
So how do I do to change all the lines and collumns?
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.
- I tried like that and doesn't work.
Igorfm7 What does that mean "It doesn't work"? What did you try exactly?
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.