Clustered Column/Bar Chart with grouping and ordering

[pfInigo]

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

[pfInigo]

Sorry I should have been more clear - there are two values in my chart (i.e two columns)

There is a parent (A) and children (B) and two values Premium and Losses - as per below. 

Is there a way to do what I am trying?

[Arul]

@pfInigo ,

Would be helpful if you provide the sample data?

Thanks,

Arul

[Arul]

@pfInigo ,

drill down is the option as you see in the below image,

Thanks,

Arul