how to sort the data values in the bar chart which includes number and strings

[abc_18]

Hello everyone,

The problem is when I am creating bar chart numbers are sorting properly

and string values are also geeting arranged alphabetically, but requirement is to show the Finished first, then 3 days, 6 days and so on, please check the screenshot and give me answer as suitable..

[allorens_14 · Accepted solution]

Hello!

You can Order your dimension by an expresion.

Try this one:

MATCH(Your_dimension, 'Finished','3 days', '6 days', '12 days', '36 days', '48 days', 'Over 48 days')