You have labeled this with the tag sql-server-transact-sql
, but this is nothing you can do in T-SQL. All you can do is return an extra column to the client (in this case Tableau) that indicates that the data should be rendered in a special way.
As for how to implement that red arrow in Tableau, you will need to ask in a Tableau forum.