Forum Discussion
Loading data into powerbi
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.
- In Model view > choose Whole number and Custom format : 00#####
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
- Create a formula using FORMAT()
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
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.
- In Model view > choose Whole number and Custom format : 00#####
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings
- Create a formula using FORMAT()
Column = FORMAT(test[Project (7 digits)],"00#####")https://docs.microsoft.com/en-us/dax/format-function-dax