The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi there,
I have several columns (all columns with Est & Year in the header) that include null value and number like this 190,513. Power BI automatically recognizes this column as Text but not Number. Now, I must change the data type from Text to Whole Number. Here is what I did:
Then the whole column becomes Error (screenshot below is example of one column, it will be similar when i apply the same for the other columns).
I read some questions in the platform but still cannot solve this problem. Thank you so much for answering.
Best regards,
Bonjour,
J'ai rencontré le même souci, avez-vous trouvé la solution, SVP?
@quyenduong , Can you please click error and share that
Hi @amitchandak , I found out that the data containing numbers always have "comma" between numbers, therefore, it fails to convert to Whole number.
I saw that there is a function to replace value "," to nothing but I wonder if i can apply this for all columns containing number so I dont have to do it one by one.
Thank you
Hi @quyenduong
Thanks for reaching out to us.
Usually a number column is automatically recognized as a number column, unless the number contains some spaces, then the column will be recognized as text type. Could you share a sample file for us to check? thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
95 | |
84 | |
66 | |
61 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |