Multiple time dimensions in one Bar chart

[mariam_vd]

Hello, I have a requirement to create a BarChart, which will show the weekly values and their aggregations for Months and Years simultaneously. 

See the mockup done in Excel below.

I've created the alternative dimensions, but that solution is not sufficient. 

Do you happen to know the best practices for such a graph? 

[anat]

we should have all Year,Month and Week values in single filed

Table1:

load Date,Month as NewDate resident table;

concatenate(Table1)load Date,Year as NewDate resident table;

concatenate(Table1)load Date,Week as NewDate resident table;

Date should be the join with fact table then use Newdate as dim .

but this is not the best approach