Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to group date using a week End Date column ?

Hi Community,

 

I have a column that is Date data type . I want to create Start Date and End Date using the same Column . Here , I want Start Date and End date to be Previous Week Monday and Current Week Monday . 

 

I created 2 Calculated columns  as shown below  . 

 

Week Start Date = SSPR[ActivityDateTime] - WEEKDAY( SSPR[ActivityDateTime],2 ) + 1
Week End Date = SSPR[ActivityDateTime] + 8 - WEEKDAY( SSPR[ActivityDateTime],2 )
 
I am getting the dates properly as shown below in screen shot. 
 
Capture.JPG
 
Now, i want to group data by Week End Date and do a count of rows to show them in Stacked column chart  . When i do that , I am getting a visual like shown below. The dates in X-Axis are not coming correctly . They are showing dates of Sundays of every week. But I want to show the Mondays which is Week End date of every week . 
 
Capture.JPG
 
Kindly help . 
 
G Venkatesh 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

@Anonymous 
The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.

Vpazhenmsft_0-1630896027903.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@Anonymous 
The group bin feature for data column will group based on the whole date. Try change the date type to Text, create groups with the text date in the x-axis.

Vpazhenmsft_0-1630896027903.png

 

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , are you using weekend date column on the x-axis. I doubt that. Because date is not same.

 

Also, make sure the axis is categorical

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi Amit,

 

Yes I have created group(bins) based on Weekend Date as Direct Column of Weekend Date is not grouping data . When I add the new column based of Grouped bins Weekend date, thats where dates appeared differently. 

 

Yes I have turned the Axis type from Continous to Categorical. 

 

Thanks,

G Venkatesh 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.