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