Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have rather a peculiar problem. I have 6 columns in a table. One of the columns is named "Amount". Now this column is misbehaving. This column has values ranging from 100k to 10M. I have imported data from an excel file. some of the rows are showing proper values, while others are not. For eg. row A in excel has 450k and the same row in PowebI shows 450k. Row B in Excel has 350K but powerBi table shows that value as 35M. Please help me solve this issue.
@Greg_Deckler Thank you for replying. I was calculating them in power query, but my issue is solved. Thank you again for reaching out.
@LordSnow Are there any calculations involved or are you doing a straight import from Excel and this is how the data shows up in the Data view in Power BI?
User | Count |
---|---|
93 | |
86 | |
78 | |
72 | |
65 |
User | Count |
---|---|
115 | |
107 | |
85 | |
65 | |
64 |