Only Show Complete Weeks

[cheid]

I have dashboard that utilizes the below calendar slicer.  When you select a full month (Ex. May) as shown below, the data only shows May 1-3, but leaves off April data.  How do I exclude incomplete weeks when using the slicer below?  Thanks.

[v-ssriganesh]

Hello @cheid,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[PhilipTreacy]

Hi @cheid 

If you have selected only the whole month of May and you are only seeing data for May 1st - 3rd, then that implies you only have data for those dates.

If you have selected only May, then no data for April wil be shown, that's how the slicer works.  I'm not sure why you expect April data to be shown if you have filtered only for May?  Perhaps you could explain again?

Also, can you clarify what you mean by incomplete weeks?

Regards

Phil

[v-ssriganesh]

Hi @cheid,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @rajendraongole1 for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[rajendraongole1 · Accepted solution]

Hi @cheid  -  You'll need a column that identifies if a specific date falls within a complete week. The definition of a "complete week" is typically a week that has passed completely up to the latest date in your dataset.

you can also watch this video step by step:

Dynamically Remove Incomplete Week Dates from The Visual in Power BI

HOpe this helps.

check it and let me know.