I have a slicer filter on my report for a three of thousands of IDs. It would be great using search function (on the ellipses) but unfortunately only works with values formated as text. I can not reformat my column due to access restrictions of the database, so thought it creating a duplicated column with a DAX formula that mirrors the original would do the trick. Due to same restrictions I can not simply add a column onto the database. Unfortunately my DAX knowledge is close to none.
In essence, I am looking for a way to duplicate an entire column through a DAX formula so I can format as text this new column
@Fowmy thansk for taking the time to reply. Unfortunately accessing to inner data is restricted, hence the need for using dax formula to replicate the original column, see below snap showing we only have "Report" option
@v-zhenbw-msft thanks for taking the time to respond. it is a live connection indeed and yes there is no possibility to change the format on the original column. That is why I thought a potential workaround would be duplicating that column through DAX formula and then formatting that new column once you have it in the "Fields" section.
I am not skilled in DAX so apologies if there is any misinterpretation on how it actually works on my explanations