1 of 1 people found this helpful
You can do float into string - str([Data])
Is Banner a string?
Tried this, but I assume converting it to a string messes with the fact that [Data] is a measure, so my sum's (obviously) break.
Also, yes banner is a string. Basically it represents how the data is cut (columns).
In the absence of a format() or text() function (which is often asked for), your best best is to separate data out.
For example a measure called Dollars may be
IF (left([Banner],1) = "$") THEN [Data]) END
And there may be X more for the rest of the measure types
This of course then affects any filters you have to change the measure on the chart