Forum Discussion
Solved
Leading Zero
Hello, I am trying to set up some store numbers in Power BI so we can view information by store specifically. When I enter the store numbers, PowerBI will list items by leading number instead of ...
If your source data has leading zeros, then you need to solve this when you import the data (assuming you are not connecting directly to the data source), by making sure you format the column as text in the query editor. Otherwise, you will need to create a calculated column that pads the store IDs with the correct number of leading zeros.
Hi, I found the solution here. Had the same issue.
https://radacad.com/add-leading-zeros-to-a-number-in-power-bi-using-power-query