cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
benjaminhoang
Helper III
Helper III

In this week issue

Hello everyone!

 

I find it so frustrating that I can not choose what is consider this week through power bi. Has anyone else had this issue? For our partcular reporting needs we need monday to sunday to be conisder in this week but the only option that is given is Sunday to Saturday. Does anyone have any solutions? I know I can manually pick this days with selection but I were to do that every week for all our reporting it would be so time consuming

 

 

 

111.PNG

1 ACCEPTED SOLUTION
v-danhe-msft
Microsoft
Microsoft

Hi @benjaminhoang,

Based on my research, the feature is by design, if you want to show the data from 2019/2/9 to 2019/2/15 in a week, you could try to create a new data:

Date+1 = [Date]+1

1.PNG

Use this new column as filter and you could see the result:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-danhe-msft
Microsoft
Microsoft

Hi @benjaminhoang,

Based on my research, the feature is by design, if you want to show the data from 2019/2/9 to 2019/2/15 in a week, you could try to create a new data:

Date+1 = [Date]+1

1.PNG

Use this new column as filter and you could see the result:

1.PNG

You could also download the pbix file to have a view.

 

Regards,

Daniel He

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

It worked! but I needed to do -1 because I needed days Monday to Sunday. Thank you.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors