Forum Discussion
A numeric looking text column cannot be converted to number
I apologize for the delayed response due to my busy schedule. I'm experiencing an issue with a measure in Power BI. There's a relationship between the 'Value' field in the 'Time_period' table and the 'Value' field in the 'Master_Table'. However, when I try to use the measure to fetch the selected value from 'Time_period'[Value] independently, it returns a blank value.
When I break the relationship then and its working fine. No need to convert the value field in Master_table into numeric value.
Super UserHi basaknilabja
Please follow below Steps to fix in Power Query:
1. Open Power Query Editor
Go to Transform Data.
2. Remove non-numeric characters (keep digits, dot, and minus)
= Text.Select([YourColumn], {"0".."9", ".", "-"})
3. Trim and clean
Even after Text.Select, some invisible characters might remain. So also apply:
Transform > Format > Trim
Transform > Format > Clean
These options remove whitespace and control characters.
4. Convert to number
Transform > Data Type > Decimal Number or Whole Number
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!