Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
All,
I have some data with some mixed data types. A column that is primarily a number but some of the numbers are like 03E5642 and that is trned into infinity. If I chage it to text data type it just shows the infinity symbol. Any ideas how I can change this to show the data as it is entered?
Thanks,
Solved! Go to Solution.
Ok. What transformation steps have you applied to this table? Has the original data been converted to number, then to text, without overwriting the number change step? How does this field look when you select the source or navigation steps - are the infinity symbols already there?
Pete
Proud to be a Datanaut!
Hi @StephenGW ,
It sounds like you're trying to change the data type in the Desktop report view. If so, then you're not actually changing the data type, just the display format of the underlying data. As the underlying data is passed to the data model as number type, then the underlying data will continue to show 'infinity' and this can't be overridden by changing the display format.
You need to change the data type of your field to Text in Power Query. This should then pass through to the Desktop report view correctly.
Pete
Proud to be a Datanaut!
Ok. What transformation steps have you applied to this table? Has the original data been converted to number, then to text, without overwriting the number change step? How does this field look when you select the source or navigation steps - are the infinity symbols already there?
Pete
Proud to be a Datanaut!
Ahh there it is. In the Navigaton step it is showing as Any type and showing the numbers correctly. I removed the Change change of data type steps and re-did them. Everything is good now!
Thank you!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |