Forum Discussion
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 type the filter only works as list
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/
5 Replies
Hello I don't exactly get your aim.
Maybe it works for you to have to columns, one as number formatting (VALUE([register]) to convert Text to number
and anohter one with text for displaying (FORMAT([register],"0000000") depending on wether you have text or number in register.
So you could calculate with your numeric column, but display the text column.
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
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
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/
