Solved: How to display an integer with a leading zero

webportal · ‎12-02-2020

Hello,

Is it possible to format an integer in a column that varies from 0 to 12, to be displayed as 00 to 12.

NOTE: I want to preserve this field as an integer and NOT as a text.

Thank you

mahoneypat · ‎12-02-2020

You can do this by going to the Diagram View (shows tables and relationships), selecting the column of interest, under Format on right choose Custom and put in the # of 0s you want.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎12-02-2020

You can do this by going to the Diagram View (shows tables and relationships), selecting the column of interest, under Format on right choose Custom and put in the # of 0s you want.

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube