Power BI Desktop/Service

Hi Nitin_Patil 

Power BI slicers don't retain the exact formatting of spaces due to their default behavior that ignores additional white space in text strings. This is why the dynamic spacing in the calculated column is lost when used.

You can try padding the Customer ID with leading zeros to ensure that all IDs have the same length, which might help maintain better alignment.

Lastly, you might consider providing feedback to Microsoft on the Power BI community forum as a feature request.

Home (microsoft.com)

^{Best Regards,}

^Jayleny

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}