I have created a derived column Row_ID with Static value as Number 000 in visual expression builder but preview time its showing only single digit as 0

I have created a derived column Row_ID with Static value as Number 000 in visual expression builder but preview time its showing only single digit as 0

@ARUPDEBBURMAN-2424 we haven't heard back from you. are you still facing the issue?
You probably want '000' not the number 000.
Hello @ARUPDEBBURMAN-2424 and welcome to Microsoft Q&A.
@Kiran-MSFT is correct.
The reason you are seeing 0 , not 000 , is because you chose that column to be integer. As a number, 0 is the canonical form for the value of zero. 000 = 00 = 0 , all are the value zero.
If you care about the presentation, you will need to change the column's data type to string, and use the text value '000' not 000 as Kiran said.
5 people are following this question.