cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JaimeW Frequent Visitor
Frequent Visitor

Selecting split weeks per month

Hello,

I'm fairly new in using PowerBI, but I need help in understanding how I can select split work weeks between months.  We use the system to show our teams time entry per project.  Our weeks go Monday-Sunday, and I am trying to create a report to show time entry for Feb 26-March 4th.  I am unable to select Month 3 week 1 when I have Month 2 and Week 5 selected.

 

powerbi issue.JPG

3 REPLIES 3
JaimeW Frequent Visitor
Frequent Visitor

How to show weekly hours when part of the week is in the previous month

We use PowerBI to show hours worked on our projects.  However, I am unable to figure out how to select a split week.  For example, last week's time should show Febreary 26-March 4th, however, how we have it set up I am only able to select Month 3 week 1 OR Month 2 Week 5.  I am unable to ctrl select both as the month is not available for March when I select February. 

 

 

Super User
Super User

Re: Selecting split weeks per month

So, one way to handle this would be to not have your Month slicer cross-filter your Week slicer. You do that by selecting your Month slicer, clicking on "Format" under "Visual Tools" and then clicking "Edit Interactions". Then you would click the Ghostbuster icon on your week slicer and then click Edit Iteractions again.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

JaimeW Frequent Visitor
Frequent Visitor

Re: Selecting split weeks per month

Could you let me know what the ghostbuster icon is?

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 6 members 1,693 guests
Please welcome our newest community members: