Forum Discussion
Power BI changing values when importing Excel sheet
When I pull an Excel spreadsheet with data like this into Power BI
| 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.00 |
| 5 | Pokemon Red/Pokemon Blue | GB | 1996 | Role-Playing | Nintendo | $11.27 | $8.89 | $10.22 | $1.00 | $31.37 |
| 6 | Tetris | GB | 1989 | Puzzle | Nintendo | $23.20 | $2.26 | $4.22 | $0.58 | $30.26 |
| 7 | New Super Mario Bros. | DS | 2006 | Platform | Nintendo | $11.38 | $9.23 | $6.50 | $2.90 | $30.01 |
| 8 | Wii Play | Wii | 2006 | Misc | Nintendo | $14.03 | $9.20 | $2.93 | $2.85 | $29.02 |
| 9 | New Super Mario Bros. Wii | Wii | 2009 | Platform | Nintendo | $14.59 | $7.06 | $4.70 | $2.26 | $28.62 |
| 10 | Duck Hunt | NES | 1984 | Shooter | Nintendo | $26.93 | $0.63 | $0.28 | $0.47 | $28.31 |
| 11 | Nintendogs | DS | 2005 | Simulation | Nintendo | $9.07 | $11.00 | $1.93 | $2.75 | $24.76 |
it looks the same in the Power BI Navigator window (note the sales values columns) but when I load it looks like this in the Table view
Note the sales values again.
Any guidance would be greatly appreciated. [email protected]
