Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hi ,
How can i load data into power bi as text : example 0090015?
the first 3 record in my data loaded , it trim the first 2 zero
Here is the link to my file
https://1drv.ms/x/s!ApIDnMK2eKiFgQcBMkuQB3U0lybN?e=uigm9J
thanks
Solved! Go to Solution.
Hi @ktt777 ,
I have checked your data source. The original data doesn't contain "00".
There are two ways that can implement it. You could follow my step to have a try.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Column = FORMAT(test[Project (7 digits)],"00#####")
https://docs.microsoft.com/en-us/dax/format-function-dax
Hi,
You can add a Custom column as
Leading zeros = Text.PadStart(Number.ToText([Column2]),7,"0")
It should resolve your problem.
Thanks
Hi,
You can add a Custom column as
Leading zeros = Text.PadStart(Number.ToText([Column2]),7,"0")
It should resolve your problem.
Thanks
Try to select that column and change it's format to Text.
@ktt777 , check the data type. It should be text. Change it in Data Transformation mode /edit query mode.
when i change to text, it trim the first 2 zeros
@ktt777 , OPen data transformation mode, Right-click on Table. Open Advance editor.
It should have a data type there. Is the the data type is text and it is still removing leading 0 ?
yes, the data type is text but the zeros are removed
Do you know what is the difference in data in cell B5 and B7.
Data in cell B7 will be kept, only zeros in B5 are removed
Thanks.
Hi @ktt777 ,
I have checked your data source. The original data doesn't contain "00".
There are two ways that can implement it. You could follow my step to have a try.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
Column = FORMAT(test[Project (7 digits)],"00#####")
https://docs.microsoft.com/en-us/dax/format-function-dax
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |