Add Leading Zeroes in Power BI (Text and Number Values)

Save
2 years ago
2

How to add leading zeroes in Power BI, both to text and number values.

This video shows two examples of adding leading zeroes to a number. An example in Power Query, and then using custom number formatting in Power BI.

Timings
00:00 - Add leading zeroes in Power BI
00:26 - Stores values as text
01:12 - Use Number.ToText in Power Query
02:27 - Custom number formatting in Power BI

Find more great free tutorials at; https://www.computergaga.com

*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Excel VBA for Beginners â–º http://bit.ly/37XSKfZ
Advanced Excel Tricks â–º https://bit.ly/3CGCm3M
Excel Formulas Made Easy â–º http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel â–º http://bit.ly/2Siivkm

Connect with us!
LinkedIn â–º https://www.linkedin.com/in/alanmurray-computergaga/
Instagram â–º https://www.instagram.com/computergaga1/
Twitter â–º http://www.twitter.com/computergaga1

Loading comments...