The ‘Size’ option in the Points command will size the markers based on data, but only works for numerical columns. The reason is that the point size is replaced with a numerical value from the data table multiplied by a scaling factor.
What you can do is map your text values to a numerical value. There are a number of built-in options for mapping a text column to numerical values, that are very quick. We just updated the documentation on the Text column to make clearer how this works.
Once the text values are mapped to a number value it can be used to scale the Points.
Does this help you?