Forum Discussion
Customizing User Inputs in the Text Slicer Visual on PBI Desktop
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
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.
Hi Uttasarga ,
The Text Slicer itself does not support transforming input. It takes the user's typed value exactly as-is and tries to match it with what's in the column used in the slicer. If the provided workaround does not match your requirements and
If the feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community,
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
Thank you