Line graph or comparable with string values

[p1ngu1n]

Hi all,

I have a column where the data is stored as string, lets assume "LOW", "MIDDLE" and "HIGH".

What I want to do is to visualize this in a kind of state diagram, I thought of a line chart with stepped lines.

1.) Is there any possiblity to visualize this data without transforming it to integer, such as 1, 2 and 3 for the three values?

2.) If it is required to transform the data, how can I use "LOW", "MIDDLE" and "HIGH" on the y axis to make clear what the values stand for?

BR and thanks!

[dax]

Hi @p1ngu1n , 

I think you need to use number instead of text type in y axis. In addition, if you want to show high, middle, low , you could try to use analytics->trend line in chart to show it. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[p1ngu1n · Accepted solution]

@dax Thank you for you idea.

The way I worked around now is to create a column with integer values and use the column with text values as legend. Might be too complicated but works for me 🙂