Stacked Column Chart - Show month date hierarchy split by years

Hey,

I guess this pbix file contains what you are looking for:

To achieve the above it's necessary switch off the property "Concatenate labels", use the Year and Month column on the x-axis and "Expand all down ..."

Of course it's also possible to use just the column "Year-MM" from the Calendar table.

Hopefully this is what you are looking for.

Regards,

Tom

Hey,

not sure what you are asking for, but it's maybe how I created both of the tables ...

The Calendar table is created by a DAX statement, just mark the table and the DAX formula bar shows the DAX statement.

The table "fact" has been created by using the function "Enter data" that is available from the Report view (top icon on the left side).

Home (menu) --> External Data (ribbon) --> Enter Data. What might confuses you if you are not familiar with the function "Enter data", this works just once ... After the initial input, and most of the time I want to or have to add more data or delete data - editing a table is different. For editing data, it's necessary to enter Power Query, then hit the gear icon of the Source step of the table you want to edit:

Hopefully, this is what you are looking for!

Regards,
Tom