Forum Discussion
Solved
zero left
I need to create a filter between two records in a register that starts with 0000001, 0000002, ..... 0000100 and power bi does not allow numeric formatting with leading zeros and if field is text typ...
Hi acarlos
You can use my blog post, which will add the required amount of zero's to your data.
To complete it, you will need to make the changes in the Power Query Editor (Edit Queries) window
https://www.fourmoo.com/2015/03/25/power-query-adding-leading-zero-to-number-eg-month-number/
I need a numerical field with leading zeros to use a filter between two values:
000001,00002,00003,....,000099,000100
select 000040 between 000050 for example
so the field has to be numerical with leading zeros but power bi does not allow this formatting
if field is text only allows filter in list without intervals