Nested x axis in Graph

[Route11]

Hi experts

I am trying to plot a nested x axis in a stacked or your standard column chart in Power BI and it's turning into a nightmare...

I have [FONT=&quot] Turn on responsive under "General" formatting and Turn off "Concatenate labels" under X-Axis..

cannot see the wood for the trees....sample data below

[/FONT]

Division	Location	Values
10	FEM	1
10	london	2
11	london	3
11	FEM	4
9	FEM	4
9	London	1
9	Spain	23
8	India	4
8	London	5

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

[FONT=&quot]
[/FONT]