Help on drill down with hierarchy in chart

SOrry we cant do like this, bec we cant set Staic X Axis inhierarchy level.

While you can't keep Year fixed on the axis, you could create a measure that tells the current year selected and display it on a card.  Check out this post for a way of doing this:

https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/

While you can't keep Year fixed on the axis, you could create a measure that tells the current year selected and display it on a card.  Check out this post for a way of doing this:

While this is not directly possible in Power BI, there is a simple workaround to achieve this.

Steps
1. Create a new table with the hierarchy columns in normalized form

ie. if your dimension data is as follows (Original_Table)

create a new table with the data normalized to the following format (Normalized_Table)

One way of achieving this on SQL is - 

select * into Normalized_Table from
(
select
distinct
Category,
Sub_Category,
1 as Level
from Original_Table

union

select
distinct
Sub_Category as Category,
Sub_Category,
2 as Level
from Normalized_Table
) Original_Table;

2. Create a bi-directional relationship from the Normalized_Table[Sub_Category] referring to Original_Table[Sub_Category]

3. Now add Normalized_Table[Level] as a slicer set to single selection and defaulted to 1

4. Create the stacked bar chart (or any other visual) with Normalized_Table[Category] as the legend

Now when '1' is selected in the slicer, the stack displays at Category level and when '2' is selected in the slicer, the stack displays at sub-category level

Vivek