Clustered Column/Bar Chart with grouping and ordering

Hi,

I want to display data in a column/bar chart as I was previously able in Excel Pivot Chart (see below).

The chart has grouped the Years by Syndicate Number and order them by the Amount. 

However, I can't seem to find the setting in PowerBI to do this, and the drilldown does not do what I want it to do.

I feel I am potenitally missing something obvious.

Thanks in advance,

Paul