zero left

[acarlos]

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

[v-chuncz-msft]

@acarlos,

As mentioned above, you may add a slicer based on a calculated column.

[acarlos]

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

[GilbertQ · Accepted solution]

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/

[acarlos]

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

[Floriankx]

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.