sort a chart by custom oder not working

[paulista]

Below is my expression :

Match(eventname,'MANUALCASECOMPLETED-CPVT-REJECTED
','APPROVEDATAOVERRIDE-REJECTED
','REVIEWCASECOMPLETED-CPVT-REJECTED
','CMREVIEWCOMPLETED-CM-REJECTED
','CONFIRMREQUESTCOMPLETED-CM-REJECTED
','REVIEWAMENDREQUESTCOMPLETED-CPVT-REJECTED
','BATCH-REJECTED
','REPORT-REJECTED
','DATAQACOMPLETED-REJECTED
','METHODOLOGYQACOMPLETED-REJECTED
','REVIEWREPORTCLAIMED-CM-REJECTED')

and snapshot of the graph. any idea why is not working

[Gysbert_Wassenaar · Accepted solution]

---

Match(eventname,'MANUALCASECOMPLETED-CPVT-REJECTED
','APPROVEDATAOVERRIDE-REJECTED
','REVIEWCASECOMPLETED-CPVT-REJECTED
','CMREVIEWCOMPLETED-CM-REJECTED

---

It looks like you include a line break in your labels. Do they really include a line break? If the eventname values don't and the labels you put in your match function do then they won't match.

You might also want to use Only({1} eventname) instead of just eventname to make sure selections don't mess up the sorting order.