Forum Discussion
Solved
Only Show Complete Weeks
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 ...
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.
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.