Have you read these two articles?
https://ginameronek.com/2014/10/01/its-just-a-matter-of-time-power-bi-date-time-dimension-toolkit/
Hope this helps and if it doesn’t please supply a sample PBIX file so forum members can better assist you.
1 Like