Custom sort not working

Hello,

I have a table named Glossary that contains KPIs and other details. Additionally, I’ve created a custom sort table that includes KPI names and their corresponding sort order. A relationship has been established between the two tables using the unique KPI name field. Then I have applied sort functionality for sort order under column tools.

However, in the table visual, the KPIs do not appear to be sorted as expected. I would appreciate any suggestions or guidance on how to resolve this sorting issue.