Forum Discussion

phelms2's avatar
phelms2
Regular Visitor
1 year ago

Reference labels on New Card Visual autoformat numbers (column type: Text) - no way to change it?!

have a New Card Visual where I need to provide a year for reference. Since some of the years are with text (i.e. FY2025), the column has "Text" as datatype. Now, when I insert the year in a refere...
Reports
vojtechsima's avatar
vojtechsima
Super User
1 year ago

Hi, phelms2 

very interesting issue you found.

 

Here's fix I came up with.

 

Create a measure instead of directly using the column, the column needs to be TEXT (set in Power Query), in the measure add invisible character like this (I cannot copy the code, because it's invisible in this editor) 

 

Copy the character from here:
https://www.editpad.org/tool/invisible-character

 

then use it as the label and it's gonna work: