How to use date of Sunday for week intervals instead of week number in time hierarchy

[Ahmad_16]

Hello, 

I need to show the date of Sunday in week intervals instead of using week numbers 

check the pic

 

[Mkarwa-123 · Accepted solution]

Hi @Ahmad_16 
you can add new column to your date table and use it on x-axis.

WeekStart1 = 'Date Dimension'[Date] - WEEKDAY('Date Dimension'[Date],1)+1

Did I answer your question? Mark my post as a solution!