Card (New) Not displaying leading 0s in ID numbers formatted as text

[jjasminf]

I'm using the Reference label feature in the Card (New) visual. I have ID numbers that I've formatted as text in Power Query. Numbers that begin with 0 appear just fine when I use the ID field as a regular callout value. However, if I use the field as reference label, it treats the value as a number. So 03000 becomes 3K. 0001 becomes 1. I've tried using a DAX measure an that did not work. Is this an oversight or by design? Any workarounds or something I'm missing?

**UPDATE: 
I'm using a workaround using UNICHAR(8203). I created a calculated column that adds this zero space width character at the beginning of all ID numbers. It doese the job right now, but would still like to know if there is a better way to do this. 

[v-nmadadi-msft]

Hi @jjasminf 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[jjasminf]

I still think it's an oversight in the feature. I 'm using the workaround I stimbled upon (creating a custom column to lead with unichar8203). If anyone has a better way to do this or if a fix becomes available, please let me know. FOr now, I have marked my workaround as a solution. 

[v-nmadadi-msft]

Hi @jjasminf 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[ajaybabuinturi]

Hi @jjasminf,
Whatever you did that's correct, it should be work. Could you please provide the sample data of .pbix file so that I will provide exact solution.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.

[jjasminf · Accepted solution]

It's set as Text.
 

But treated as a number when used as a Reference Label.

Treated as text when used as the regular card value. 

I had to create a new column to lead with Unichar 8203.

This works for what I need right now. But is there a "proper" way to do this?

[v-nmadadi-msft]

Hi @jjasminf ,

Thanks for reaching out to the Microsoft fabric community forum.

I tried to look for an alternate solution but for now I think using the calculated column is the best alternate approach.

If your IDs have consistent length, you can rebuild them as text with leading zeros:

TextID = FORMAT([ID], "00000")

But since your values already are text, this doesn’t fix the type inference issue it’s just a safeguard if you ever convert to numeric upstream.

I hope this information helps. Please do let us know if you have any further queries.
Thank you