Hi. I've created a custom column and when I check again on power BI, it turns out all the calculations are in text values. Can anyone point out where did it go wrong? Or where can I edit the value type?
I tried to change the data type here but it won't work.
@Anonymous
If you are 100% sure that this column doesnt include any text then you can go to Power Query editor --> Right click on Column Heading --> Change Type
If text exists then make sure you replace text with a numeric value e.g. Zero
Follow same process above and istead of change Type select replace values
Image below
________________________
If this post helps, then please Accept it as the solution to help other community members find it more quickly
Click on the Thumbs-Up icon if you like this reply.
Check out my COVID-19 Report in Data Stories Gallery: COVID-19 Report
@Anonymous
If you are 100% sure that this column doesnt include any text then you can go to Power Query editor --> Right click on Column Heading --> Change Type
If text exists then make sure you replace text with a numeric value e.g. Zero
Follow same process above and istead of change Type select replace values
Image below
________________________
If this post helps, then please Accept it as the solution to help other community members find it more quickly
Click on the Thumbs-Up icon if you like this reply.
Check out my COVID-19 Report in Data Stories Gallery: COVID-19 Report
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Join our Community Sticker Challenge 2025
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Fabric Community Update - February 2025
Find out what's new and trending in the Fabric community.
