Table view shows different results for custom column created in power query

[jonmaas]

Hello everyone,

I am currently playing around with using unichar characters to visualize textual status values. To do this I created a custom column in power query (because I read somewhere that those are better than using calc. columns) that checks the value of a column called Statuswert using if and output a unichar character depending on the value. This is the M Code for the custom column:

= Table.AddColumn(#"Uppercased Text", "Statussymbol_", each if [Statusname]="status_cluster" then (
if [Statuswert]="LIVE" then Character.FromNumber(9989) else if [Statuswert]="REJECTED" then Character.FromNumber(10071) else if [Statuswert]="BLOCKED" then Character.FromNumber(9940) else Character.FromNumber(128346))
else "Not StatusCluster")


This is how it would (and should) look in the power query editor:

As soon as I load the data into the model and check within the table view I get different Unichars displayed for the very same EAN:

Surprisingly, if I reduce the variety of symbols  (by filtering out 1 or 2 of the 4 in the power query editor) the result gets displayed correctly in table view:

Does anyone have a clue what could be causing this? I am at my wits end

[jonmaas]

I gave in and tried rebuilding the data model in a new file. The issue still persists in a new file. I have so far tried the following:
-Start in a completely new file
-Tried using power query (correct results shown in query editor, wrong in table view)
-Tried using calculated columns (Displayed the correct symbols on friday right after creating the column, Today after data refresh the calculated column now also shows the wrong symbols!!!)
-Tried swapping UNICHAR (or Character.FromNumber in M) for directly inserting the Symbol like this "⛔"

Maybe I should mention that I am generating these unichar characters for a large table (>400k rows). My guess would be some sort of bug that only occours if the table is long/large enough?

[lbendlin]

cannot reproduce

see attached - please advise.

[jonmaas]

It appears like my file got corrupted somehow? I just tried recreating your table within my project and it also changes the unichars between query editor view and table view. I'd really like to avoid rebuilding my model with all its relationships again from scratch. Does anyone have a clue on how to fix this without just rebuilding the project manually? I already cleared the cache and refreshed multiple times.