Bar chart sorting by expression

ali_hijazi — Tue, 04 Apr 2023 06:18:27 GMT

Hello
got a barchart with two dimensions : Fiscal Year, and Region
in this barchart I'm displaying the total by the above dimesions plus the values
so the Region dimension is calculated dimension as follows: pick(Total,Region, 'Total')
Total is a dimension I created in the script from an inline table with two values 1, and 2
so far so good

Now I want to sort the result not as acending / descending but custom as follows:
Match
(
Only({1} [BUSINESS_UNIT_DESC]),
'Canada','Latin America','United States'
,'BU1','BU2','BU3','BU4','BU5','AM',
'Central Europe','France Benelux','MEA','Nordics Russia','Southern Europe + Morocco','UKI','Total'
)

I'm getting the following result:

but I want the Total to be placed on the far-right
so how can I update the formula of sorting to accoplish this

topic Bar chart sorting by expression in App Development

Bar chart sorting by expression