Customizing User Inputs in the Text Slicer Visual on PBI Desktop

[Uttasarga]

Hi Fellow PBI'xers, I've a report that has a Text Slicer Visual (Preview Feature), in which what I want to do is lpad default "0000"  to the user's input, until the point where the input string is 14 Digits in Length.

Example - If the user inputs "1234567", then the text slicer should add leading zeros to this input, thus making it "00000001234567".

[v-nmadadi-msft]

Hi @Uttasarga  ,
Thanks for reaching out to the Microsoft fabric community forum.

A workaround for what you are trying to achieve is by using Duplicate column in transform data

With that duplicated column, you can split the column by based on number of characters

Now you will get 1234567 as a separate column, you can directly enter it into the input to filter the visuals of your choice.


If this post helps, then please consider Accepting as solution to help the other members find it more quickly and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you

[Uttasarga]

Hi @v-nmadadi-msft , but that would mean to remove leading zeros from the column values.
My report is using Direct Query, and the data volume is 8M rows on avg, each day since the past 4 years. Doing a customization you mentioned above will not be supported by Direct Query.

[lbendlin]

Why not do the padding in the UDF?

[Uttasarga]

Hey @lbendlin , so I should create a UDF that does the padding of user inputs in the text slicer?

[lbendlin]

That would be my suggestion. Where are you planning to store the user input?

[Uttasarga]

Do you have an example I can use? User's Input will be in a Text Slicer Visual