Truncated View for a Question in a Dashboard?

Hello,

I have written a question with the SQL editor that returns the results from a query. It automatically truncates after 125 characters when I view the question. However, when I add the same question to a Dashboard, the view displays the whole string, which makes it difficult to use. I've tried to play around with it but the solution that I found is to use substring to trim it down to the desired length, but that removes some of the data. Does anyone know of a way to edit this view on a Dashboard?

Many thanks,

image

image Truncated View for a Question in a Dashboard?